Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

SUBSTRING is used to retrieve part of a string from another string The syntax for the function is as follows

SUBSTRING(string_to_remove_string_from, start_position, length) 6> SELECT SUBSTRING("rntsoft rntsoft",2,3) 7> GO ------ ava (1 rows affected)