SQL Server/T-SQL/String Functions/Substring

Substring: get the substring

1> DECLARE @FullName VarChar(25)
2> SET @FullName = "www.sqle.ru"
3> SELECT SUBSTRING(@FullName, CHARINDEX(".", @FullName) + 1, LEN(@FullName))
4> GO
-------------------------
sqle.ru
(1 rows affected)
1>
2>

SUBSTRING(): starts at a position and counts characters to the right, returning a substring of a specified length

1> -- SUBSTRING(): starts at a position and counts characters to the right, 
returning a substring of a specified length.
2>
3> DECLARE @FullName VarChar(25)
4> SET @FullName = "www.sqle.ru"
5> SELECT SUBSTRING(@FullName, 4, 6)
6> GO
------
.java2
(1 rows affected)
1>
2>

SUBSTRING(string_to_remove_string_from, start_position, length)

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