--- In [email protected], Kjell Rilbe <kjell.rilbe@...> wrote: > > venussoftop skriver: > > > > Now I can I be able to do a IN against an integer iID? If not is there > > any way to convert the comma separated string to comma separated > > integer value? > > > > With a stored proc, yes, as suggested by Mark, but as I wrote far down > in my other post, you can do this: > > POSITION(sep || soughtval || sep in sep || searchedvaluelist || sep) > 0 > > Adding sep before and after each string makes sure you don't get false > hits, like '12' in '341256,234,567' where '12' appears inside '341256', > but ',12,' doesn't. > > Performance will suck, though. No indexing can be used. > > Kjell > > -- > ------------------------------ > Kjell Rilbe > DataDIA AB > E-post: kjell.rilbe@... > Telefon: 08-761 06 55 > Mobil: 0733-44 24 64 > > > > [Non-text portions of this message have been removed] >
Thanks a lot Kjell for your suggestions here. I have just posted my final query in my reply to Svein please check it out and the reasons for that implementations. Thanks again Kind regards Bhavbhuti
