Robert,
did you try looking for "data type" at the online book that comes w/SQL server?




>I want to convert a vfp db to a sqlserver db manually.
>How can i know the type of field for sqlserver
>
>like the date type
>
>VFP
>----
>DATE
>
>SQLSERVER
>---------
>?????????