Mega Code Archive

 

Categories / MSSQL / String Functions

 

Combine CHARINDEX with substring

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