Home Forums SQL Server 2005 T-SQL (SS2K5) how to verify blank spaces using substr function in SQLSERVER 2008 RE: how to verify blank spaces using substr function in SQLSERVER 2008
Pulivarthi Sasidhar
SSCertifiable
Points: 6706
More actions
April 1, 2013 at 10:06 pm
#1602653
Use Charindex function...
the following example will bring string from first letter to First Space
SUBSTRING( @STR, 1, CHARINDEX(' ',@str) )
U can loop the string until u reach End of string...