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>