Substring « String Functions « SQL Server / T-SQL






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