Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Make a string variable accept the value NULL

Status
Not open for further replies.

chrisgreen

Programmer
Jun 28, 2000
61
GB
How can I make a string variable accept a NULL value?
Thanks for your time.
 
any field can have a null.
What do you want to do with this NUll?
Test for it?

If isnull(x) then
' do somthing
end if

I usualy blank out a string by setting it to nothing
x = ""

Then later
if x= "" then
'do something
end if





DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top