>>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

Thanks for the confirmation. Sorry my typo mistake...

Regards.