Matthew Jarvis wrote: > > This doesn't work: > > SELECT dealer_name from dealers where dealer_zips like '97401*' >
Bingo... what I never saw documented is that the "*" symbol can come before as well as after the string to find... works: SELECT dealer_name from dealers where dealer_zips like '*97401*' 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.
