String Functions MSSQL

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