[thelist] Numerical Wildcard in SQL

[Rob Smith]

Hi,

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. 

Gracias,


Rob Smith
LexJet
rob.smith at lexjet.com
http://www.lexjet.com
(800)453-9538
(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)