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