Mega Code Archive

 

Categories / MSSQL / String Functions

 

Substring

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>