karthikeyan (5/29/2008)
My questions are,1) Whether my way of approach to split the comma seperated value is correct or not.
2) is there any other way to check the splitted values in the WHERE clause ? because i am using OR clause.But i feel it is not good.
3) is there any other way to do the same task ?
1) Does it work? Are you comfortable with the performance? Then YES is the answer.
2) Yes. LEFT JOIN can be used.
3) Yes.
N 56°04'39.16"
E 12°55'05.25"