Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Multiple Replaces within a field

Jun 17, 2003, 2:31 PM
cwtan76
New User (1 post)
Jun 17, 2003, 2:31 PM
Post #1 of 1
Views: 3553
Shortcut
Quote Reply
Multiple Replaces within a field
Hi everyone.

I am trying to replace '&' with 'and' in a field and it works fine using the REPLACE function. Thanks to you guys!

Now, my next query requires me to replace

'&' with 'and'

'$' and '+' with blanks.

Any help will be greatly appreciated!! Thanks!

C