undesirable characters in fields

[delaap]

Hi,
I have a field which is updated by another data source, the field contains characters that are invalid for its purpose. I cannot use i.e. / ? @ * but they are between other charcters that I do require, so my field looks like this '567AC?78'. Any ideas as to how I can replace the invalid character with a zero length string in one piece of code. At the moment I have 20 or so replace statements
Thanks

 

[JamesLean]

No easy way to do it in one statement, but you can nest replaces:

SELECT REPLACE(REPLACE(mycol, '?', ''), '@', '')

--James

 

[dan1967]

Sure, here is the SQL:

Replace(Replace(Replace(Replace(YourField,'/',''),'?',''),'@',''),'*','')

Dan.