Klas,

For C(80) I would generally use Varchar unless you expect that the field will usually be filled or close to filled, then I would use Char. For N(8,0) I'd use Integer. For G I use Image, for L I use bit, for M use Text and for D I use DateTime. There are limitations to be aware of depending on what version you use. In SQL 6.5 you can't have NULL bit fields and any Char field that accepts nulls will be stored by SQL Server as a Varchar. These limitations are removed by SQL 7.0 which handles nulls differently.

>Hi,
>
>It seems that you have quite some experience with SQL Server and I was just wondering what SQL Server data types you suggest for FoxPro types: C(80), N(8,0), G (OLE objects), L, M, D.
>
>
>Thanks...