Thanks for your help

In statements with many values tend to be inefficient as any indexes are ignored.

I would sugget building a table of your values, index this column and then use this new...

Thanks for your sugestions, I've tried them and they work.

Cheers for your help.

James