>Mark,

>It is my understanding (because I have never dealt with remote views) this
>approach would not work with data outside of VFP since Sybase doesn't know
>what to do with SUBSTRING. Hopefully someone else will jump in here and
>have a solution for you. If you are using the view designer in VFP 7.0 then
>I would advise you to use either eView or ViewEditor instead. There are
>some shortcomings to the VFP view editor that are documented around the UT.
>I have heard that these shortcomings have been addressed in VFP 8.

>HTH

Dan

That is not quite what I meant. Sybase does know what Substring means. When I create the remote view by hand, it works. (BTW: Sybase developed a Windows NT version of their SQL Server for Microsoft. This product became Microsoft SQL Server which explaines why these 2 are very alike except for the fact that Sybase runs also on Linux). It's only a shortcoming of the view editor. I'm glad these shortcomings are addressed in VFP since I will upgrade to VFP 8.0 when it comes out.

Thanks for the tip.

Mark