Regular Expression - Invalid characters
565004Mar 19 2007 — edited Mar 21 2007I have a varchar2(10) field that I need to query out records that contain any character NOT in the following list of characters.
1. alpha (any case)
2. numeric
3. space
4. &
5. - (hypen)
6. *
7. . (period)
8. ' (single quote)
9. (
10. )
11. , (comma)
12. #
13. /
Example:
When run against the below data it would only select the record with the % in it.
a8*-
1234
a8#kd
u%oO9
Thanks