Actually most of my queries are dynamic queries. So If I store my data as comma seperated values, then performance of the queries are good. That's way I am proceeding...

Hi xavier,

Thx for ur reply. But here in my case sometimes I use the query on a single column and some other times I use for more than one column....

Yes. I have worked on this. and it will work fine.

you can use NULLIF function to avoid that error. It replaes the NULL value whenever the zero occurs in the denominator.