[thelist] Numerical Wildcard in SQL
Rob Smith
rob.smith at lexjet.com
Wed Mar 1 14:12:11 CST 2006
Here's what I'm trying to get working:
SELECT TOP 100 PERCENT shopper.shopper_id, shopper.Company,
locations_shipping_zips.zip_prefix_start,
locations_shipping_zips.zip_prefix_end,
locations_shipping_zips.listing_rank, shopper.Zip
FROM dbo.lexjet_shopper CROSS JOIN
dbo.lexjet_locations_shipping_zips
WHERE (shopper.Zip BETWEEN locations_shipping_zips.zip_prefix_start
AND
locations_shipping_zips.zip_prefix_end) AND
(shopper.Zip BETWEEN 0 AND 100000) AND
(shopper.Zip LIKE '[#####]')
ORDER BY locations_shipping_zips.listing_rank
But it's also trying to match up a zip code like 91315-3111, which is
breaking the query
I hope this clears up my question,
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)
More information about the thelist
mailing list