>>>>Well, as a workaround you always can have a separate cursor created
>>>>and insert data into it from the cursor created from SQL Server.
>>>>Would this solution work?
>>
>>That's essentially what I've done as a work around.
>>
>>Select ' ' as cNumericField,numericfield from SQLServerTable into mycursor
>>
>>Then:
>>replace cNumericfield with transform(numericfield) ALL in mycursor
>>
>>It's just a big PIA to have to do that every time.
>>
>>This problem sounds like another one of those driver/odbc interpretation issues that Fox seems to have. I can't use varchar(max) I have to use text because I'm using Using driver={SQL Server Native Client 10.0}
>>
>>If I switch to a different driver I can use varchar(max) but then date fields come across as character fields which is even worse.
>>
>>I would pay $$ for a driver that actually worked with all the data types properly.
>>
>>
>>In SQL Server, Is there a way to do:
>>select transform(numericfield,'9,999,999.99') as cnumericfield
>>
>>This would at least save me from having to do that 2 part process of select then replace.
>
>Perhaps using CONVERT function to convert to MONEY type with 1 as a parameter. See
>
>http://msdn.microsoft.com/en-us/library/ms187928.aspx
Sent you a pm