>I think that is a pretty clever idea and something I will want to look at. I had been playing with storing the STR value off to a text column and having and update trigger on the backend translate that to SQL decimal(22,10)
>
>Thanks
>
>
Actually, Sergey has a very good idea. Keep this field as character in VFP and decimal (22,10) in SQL Server. As long as you don't need to do any calculations on the client, you're OK.
If it's not broken, fix it until it is.
My Blog