Help me:) Insert a Null Field 1

[mandarine]

I need to insert a null field to database but I can't
why?

dim field_number1 as string

...
sql="insert into table values ... '" & field_number1 & "')"
...

I want to insert field_number1 as NULL! I can't do it!
Could you help me?

 

[Snaggs]

You have to use the word NULL.

INSERT INTO ItemDetail (Item,Qty) Values(NULL,12) Snaggs
tribesaddict@swbell.net
To define recursion, we must first define recursion.