WNE
asked on
Useing Masks in a Query
I want to check if the data in a specific column in my database applies to a certain input mask. I don’t want to loop trough every record but to use a SQL query like “SELECT * FROM border_Att WHERE drawingnr = 000/??-####” or something like that.
Please help.
Please help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That's it. Thanks!
You can also use [A-Z] to specify alphabetic characters or equally any range of printable characters.