Thank you Ganesh, it did help.

In the meantime I have created a temp table with different collation, but I will change it and use this trick you gave me. Thanks...

thanks, and sorry about double post, it was not intentional

thanks a bunch, it worked

regards,

amira

I already had "set quoted identifier" checked. so it is not that. but thanks for the help.

amira

Thanks Yelena, it worked as you said with reports as well.

Thanks,

Amira

Thank you all. I have done it with Visual J#, but will try what Yelene told me because my employer want me to make it simple SQL Server stored procedure.

Regards,

Amira