SUBSTRING(string_to_remove_string_from, start_position, length) : Substring « String Functions « SQL Server / T-SQL






SUBSTRING(string_to_remove_string_from, start_position, length)


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

-------
java2s.

(1 rows affected)
1>
           
       








Related examples in the same category

1.SUBSTRING(): starts at a position and counts characters to the right, returning a substring of a specified length
2.Substring: get the substring
3.Combine Lower() Upper() and substring() function to capital the first letter in a word