I have a table with a field that contains a list of zip codes seperated with commas, like this:
97401.97402,97404 etc If I have any old zip code and I want to find records that contain this one in the list, what exactly is the darn syntax? No matter what I do in Access I can't get it to find any matches using the LIKE operator. This doesn't work: SELECT dealer_name from dealers where dealer_zips like '97401*' I've tried it with and w/o the single quotes, tried double quotes, tried a '%' symbol (ala postgres) and without the "*".... I miss my fox..... :( -- Matthew S. Jarvis IT Manager Bike Friday - "Performance that Packs." www.bikefriday.com 541/687-0487 x140 [EMAIL PROTECTED] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
