substitutions within string fields

[samoff]

I'd like to replace any non-alphanumeric characters in a text field with spaces.
eg. "rt/sm-01" becomes "rt sm 01" etc.

Any ideas?

sam

http:

http://www.waitallday.com

 

[foxdev]

The only immediate idea that comes to mind is a series of REPLACE() statements; cumbersome, and probably not very efficient (read: slow), but fairly easy and straightforward to code.

A second thought, one that is more flexible and easier to maintain: have a table dedicated to storing the "bad" characters, then have an SP that uses that table as a driver for the UPDATE...REPLACE statements.

Robert Bradley

http://www.foxdev.com/