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

Use CONVERT or CAST t-sql function to convert data inside your SP.