IMG-LOGO

SQL SUBSTRING()

andy - 30 Aug, 2013 3550 Views 0 Comment

The SQL SUBSTRING() function is used to return part of text or characters of a text. The substring will accept 3 parameters as below:

SUBSTRING ( expression ,start , length )

Example Customer Table

The following data table is for example only. Let's use SUBSTRING() function to return the first 4 characters from a customer table. The column we going to use are the Name column.

ID Name Age
1 Thomas Anderson 45
2 Andrew Golden 38
3 Ken Tom 30
4 Andrew Golden 36
5 Timothy Kirk 32
6 Kelly Smith 39

Example of Running SQL Query

SELECT SUBSTRING(Name, 1, 4) AS Name_Part
FROM Customers

After running the above query, it will return the following result.

Name_Part
Thom
Andr
Ken
Andr
Timo
Kell

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.

Related Blogs

How to restore database using SQL query in TSQL?

If you have a database backup bak file extension and want to restore it using SQL query You can use the built in RESTORE DATABASE function Remember in order to be able to restore a database successfully You need to ...

Related Tutorials

SQL AVG()

Learn what is AVG() function in SQL server and how to use AVG() in sql query.

SQL LCASE()

Learn what is LCASE() function in SQL server and how to use LCASE() in sql query.

SQL UCASE()

Learn what is UpperCase function in SQL server and how to use UCASE() in sql query.

SQL COUNT()

Learn what is COUNT() function in SQL server and how to use COUNT() in sql query.