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

  • nk1526 (4/2/2013)


    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

    You are learning a technique which you should rarely use & likely learning bad habits along the way.

    Use the splitter mentioned by Sean for this task.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.