SELECT event_id, title, city, state, zip, event_date
FROM Event ev, ref_mma rm
WHERE rm.area_id = 7
AND FIND_IN_SET(ev.zip, rm.zips) <> 0
AND active_ind = 1 AND private_ind = 0
The FIND_IN_SET function returns the index of the item (ev.zip) if it is
found in the set of comma delimited values (rm.zips). It returns 0 if it is
not found.
HTH
Donnie Bachan
Phone: (718) 217-2883
ICQ#: 28006783
"Nitendo Vinces - By Striving You Shall Conquer"
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
