August 26, 2002 at 9:35 am
I have a table where the last and first name are in one column with a comma separating them EX:(lastname, firstname). I need to parse and update all values in this column in my table and replace the commas with spaces.
August 26, 2002 at 9:41 am
August 26, 2002 at 10:04 am
Cool, that works on a single column. Now here's the fun part. I need to parse every column in my table to update commas with spaces. I would prefer to do it using a looping statement assigning each column name to a variable within a single update statement as opposed to using multiple update statements
August 26, 2002 at 10:24 am
Cross post, please do not cross post, please see response under http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=6401&FORUM_ID=23&CAT_ID=2&Topic_Title=parsing+a+column+to+replace+all+commas+with+spaces&Forum_Title=General
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply