How to eliminate spaces between words?

  • Hi,

       I have a [Market_Name] column, which contains something like 'Chicago North', 'Wisconsin South'.....

    How to eliminate spaces between words, so the output will be like 'ChicagoNorth', WisconsinSouth'....?

    Thank you.

     

     

  • SELECT REPLACE([Market_Name], ' ', '')

    That'll work.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply