All:
Using Crystal XI to query against an Oracle database.
Am attempting to find unauthorized (by our standards) characters in specific a database field. Using the * wild card (many characters), I need to search for any occurrences of a question mark as well as many other characters (example below).
However, I think that since Crystal (or Oracle) interprets the question mark as a "one character" wildcard, the query returns all records which have any data in the field whatsoever.
Any idea how to wild-card search for any occurrence of a question mark in any position of a particular database field using Crystal XI against an Oracle database?
{POITEMVEN.VEN_ITEM} like ["*!*", "*#*", "*$*", "*%*", "*&*", "*(*", "*)*", "*?*", "*@*", "*^*"]
Most appreciated!
Crystal Novice
Using Crystal XI to query against an Oracle database.
Am attempting to find unauthorized (by our standards) characters in specific a database field. Using the * wild card (many characters), I need to search for any occurrences of a question mark as well as many other characters (example below).
However, I think that since Crystal (or Oracle) interprets the question mark as a "one character" wildcard, the query returns all records which have any data in the field whatsoever.
Any idea how to wild-card search for any occurrence of a question mark in any position of a particular database field using Crystal XI against an Oracle database?
{POITEMVEN.VEN_ITEM} like ["*!*", "*#*", "*$*", "*%*", "*&*", "*(*", "*)*", "*?*", "*@*", "*^*"]
Most appreciated!
Crystal Novice