Help me Insert NULL field in Database Table 1

[mandarine]

Hello,

How do I insert a Null field into database table?

Let's say I have this fields:
name, address

I want to insert name as Carlos and address as NULL
can I do it in VB?

How I do it in SQL?

Thanks

 

[RickSpr]

In either VB or SQL, you use the Null keyword in place of the expression that provides the data.

VB: rst!Address = Null
SQL: UPDATE MyTable SET Address = Null WHERE ... Rick Sprague