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
May 11, 2006 at 10:01 am
#637317
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