The syntax is FLOAT(n). See BOL for details.

>What's wrong with the FLOAT syntax below? SQL is reporting an error. Everything
>else works fine.
>
>

>sCommand = "create table Recon_Info (" +;
>           "id int IDENTITY NOT NULL, " +;
>           "media_order_detail_id int NOT NULL, " +;
>           "user_name CHAR(40) NOT NULL, " +;
>           "invoice_no CHAR(40) NOT NULL, " +;
>           "batch_no CHAR(8) NOT NULL, " +;
>           "status CHAR(1) NOT NULL, " +;
>           "done_date_time datetime NOT NULL, " +;
>           "invoice_date datetime NOT NULL, " +;
>           "due_date datetime NOT NULL, " +;
>           "from_date datetime NOT NULL, " +;
>           "to_date datetime NOT NULL, " +;
>           "invoice_notes varchar NOT NULL, " +;
>           "adjustment_amt float(4,2))"
>