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