how to find use IN clause

[rahuul]

hi friends,

 

I have a table which contain some data about data, it includes a zipcode field which contain coma (,) septated values....... like (94232,94234,94235,........)

 

now i have a variable the also contain range of zip code in this format:

('94209','94211','94229')

 

pls can some one advice how i can fetch all the records matching all the zipcode in my variable with zipcodes in my data base.........

 

i tried 'IN' clause......... but not wording.............

 

pls help.................

thanks

[fenway]

That's just poor data storage design -- there is no simple facility for handling this is the data are stored that way.