Are you using remote views? If so, you can set the data type of field in the view to char (instead of memo) for your varchar fields. To do this use dbsetprop()

I don't think you can convert it from varchar to integer this way, nevertheless I am sure you can convert it to char.

>I'm running a simple stored procedure on an SQL7 server from VFP 6. The data type for the field in the SQL table is varchar and the result set I get in VFP is composed of memo fields. How do I get them to return as a string, or preferably integer, value since the data items are numbers? Thanks for any help...