Fordraiders
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I see ampapa included a link to the concept.
ASKER
used waltercook revamp
update MyTable set MyField1=remove_char(MyFie ld1);
Worked fine...
update MyTable set MyField1=remove_char(MyFie
Worked fine...
ASKER
How would this be included in a query ?
Thanks