Hi Barbadillo,

Thanks for your kind help.

I did as per your suggestion and solved the probs., but for testing purpose i add one more
Condition then i got same error.

So, The problem is in the lenght of the string,not in sql satament. Then i split this statement in to two.

Now its working fine.

Regards
Abdulla