Sql and VB

[anonymous]

[Originally posted by kev]

Hello to all,

Here is what my return recordset looks like from
a store procedure.

How do you check for empty string when it return
NULL.ÿ Or how do you test for empty string.

It very confusing.

DateDueÿ ÿ PO#ÿ ÿ  ShippedDate
===============================
1/2/2003ÿ 123ÿ ÿ ÿ ÿ 2/3/2003
Nullÿ ÿ ÿ 345ÿ ÿ ÿ ÿ 3/4/2003
1/3/2003ÿ Nullÿ ÿ ÿ  Null

Now, in VB I want to check if the string is empty.

Example

if len(trim(DateDue)isNull then
ÿ msgbox "Date Due is empty
else
ÿ msgbox "Date Due is not empty
endif

Anyone can help

thanksÿ ÿ

[anonymous]

[Originally posted by Zip]

If (IIF(isNULL(DateField,'',DateField)="") then
msgbox "DateField Required"
Else
msgbox "DateField Populated with " & DateField
End if

hope this helps

[anonymous]

[Originally posted by Chris Carta]

If I remeber...

Dim dtFld As String

dtFld = DateField & ""

Will remove a trailing null, and produce an empty string ("") if it is null...but I could be mistaken.

Chris