[thelist] Numerical Wildcard in SQL

Rob Smith rob.smith at lexjet.com
Wed Mar 1 13:37:47 CST 2006


Is there something you can use in the like clause that will match 5
numerical digits. The closest thing I've come up with so far is where
field like '_____'. Bottom line, I'm trying to cross the customer's zip
code to our preferred warehouse locations. We have the entire table of
zip code ranges linked to ware house locations. There's no "ID" to link
the two tables together, so I'm linking a range of values together. 


Rob Smith
rob.smith at lexjet.com
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236

Proud Sponsors of the Professional Digital Imaging Association (www.pdia.org)

More information about the thelist mailing list