I hope you find the cause of the problem and post it. I know I have had some problems with remote views and SQL that have caused me some long days to figure out. I use the same remote views and SPT to access data from multiple backend databases and so I have to test all views and SQL syntax on each one. The user has a choice of database storage and I don't want to maintain different versions of the same program for different database servers. Good luck.

Elmer

>
>I sincerely appreciate the effort. I shall be removing this 'collation'. To be honest, I have never used SQL enough to change any collation so am awry in figuring out how that happend!!! LOL - I can never have it easy to start with... *sigh*
>
>Thanks so much...
>
>Ric
>