Dim SQLResult As Object
SQLResult = SQL1.ExecQuerySingleResult("select date from table where date = '30-08'")
if SQLResult = Null then
lblr.Text = ""
else
lblr.Text = SQLResult
end if
Thanks. I found out that it will return "Null" if I follow up with another statement which I intended the code to be.
lblr.Text = SQL1.ExecQuerySingleResult("select TIME from table where dep = '27-08'")& " " & SQL1.ExecQuerySingleResult("select TIME from table where dep = '30-08'")