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

  • 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...