-- sql server t-sql code >>select convert(smalldatetime, convert(varchar, date_col, 101)) as date_col...>>and then deal with date display/calculations in the VFP code, e.g., if you have to calculate date difference between dates, etc. Of course, if you need that kind of calculation, you could also let SQL Server handle that, as well.
** vfp code SQLEXEC(lnHandle, "select convert(smalldatetime, convert(varchar, date_col, 101)) as date_col, etc...")