Link to home
Start Free TrialLog in
Avatar of Fordraiders
FordraidersFlag for United States of America

asked on

Strip special characters from a field

access 2000
win 2000 sp4

Database called   "MyDatabase.mdb"

Table called  "MyTable"

Fields--could be text or numeric

MyField1
MyField2
MyField3

I need the special characters stripped from  "MyField1"

Special characters like ! @ # $ % ^ & * ( ) _ - + =  { } | [ ] \ : " ; ' < > ? , . /


Thanks
fordraiders




SOLUTION
Avatar of adsmk2003
adsmk2003

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Fordraiders

ASKER

o.k.
How would this be included in a query ?

Thanks
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I see ampapa included a link to the concept.
used waltercook revamp

update MyTable set MyField1=remove_char(MyField1);


Worked fine...