>Hi all,
>
>I have this vfp table which has a compound fields as PK, which are cempno + DTOS(drec). For the SQL Server backend, I will need to change the where clause (in remote view) to cempno+convert(chr(8),drec,112) like ?pkvalue. Am I doing the right way?
>
>Regards

Yes, exactly - only a slight difference, would be char(8) not chr(8) :)
Cetin