[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