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

  • Sorry Sir

    I am trying to split sentence into words and insert into table as each word as a separate row

    This is just practicing test

    for some reason I am not able to figure out how to verify Blank spaces

    obviously some thing wrong with blanks verification in my code

    with your code I am able to remove spaces, which is good but will not solve my purpose

    thanks for help

    NK1526