[RESOLVED] Replace characters in record

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

[RESOLVED] Replace characters in record

Author

Topic

obsoletedude
Starting Member

31 Posts

Posted - 2007-03-18 : 14:40:49

Still new to SQL and having fun learning it. Here's my latest question.

I have a table 'Fields' that has a column named 'label'.
In label, I have values like 'Total Number of Orders'
I want to replace the text Number with a #. How can I do that for all records that contain 'Number'?

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-18 : 15:23:55

update fields
set label = replace(label, ' number ', ' # ')

Peter Larsson
Helsingborg, Sweden

obsoletedude
Starting Member

31 Posts

Posted - 2007-03-18 : 15:53:58

Peso,

Thanks. I didn't realize it was that easy. But, better to be safe than sorry, right?!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources