How to eliminate spaces between words?

• jenniferhu46

  SSCrazy

  Points: 2990

  More actions

  May 11, 2006 at 9:55 am

  #172558

  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.

   

   

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  May 11, 2006 at 10:01 am

  #637317

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

  That'll work.