September 2, 2009 at 4:01 pm
I have a column which has varchar data . This column data (close to 1000rows) has spaces in between . Eg : George Bush . I need to select this as GeorgeBush by removing the space here. How do I achieve this.
Or How can I select George and Bush separately from this string and then concatenate to 'GeorgeBush' like this.
Thanks
September 2, 2009 at 5:00 pm
why can't you just replace all spaces in the string?
update yourtable set yourcolumn = replace(yourcolumn,' ','')
Lowell
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply