Home Forums SQL Server 7,2000 T-SQL Finding & removing a space from a string RE: Finding & removing a space from a string

  • Now why did the multiple spaces get removed?

    'Have___a__Nice_day!' to

    'Have_a_nice_day!'

    When I wrote this originally I was scrubbing some data that had a ton of problems like this. It had been converted by several someone elses before me and they had concatinated a bunch of fields with little to no regard for spacing.


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)