Mega Code Archive

 

Categories / MSSQL / String Functions

 

SUBSTRING(string_to_remove_string_from, start_position, length)

1> -- SUBSTRING(string_to_remove_string_from, start_position, length) 2> SELECT SUBSTRING("www.rntsoft.com www.rntsoft.com",20,7) 3> GO ------- rntsoft. (1 rows affected) 1>