Replacing a character in a field 2

[dbrom]

Hi,

In my table Models I have a varchar field called modelName.
I want to replace all underscores(_) with spaces in that field for all records in the table.

Any ideas how to do it?

Thanks in advance. <Dmitriy>
dbrom@crosswinds.net

 

[Andel]

Here's how...


UPDATE Models
SET modelName = REPLACE(lastnm,'_',' ')



Hope this helps.

Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[Andel]

sorry, should be...

UPDATE Models
SET modelName = REPLACE(modelName,'_',' ')





Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[dbrom]

Thanks,
that seemed to do exactly what I wanted.


<Dmitriy>
dbrom@crosswinds.net