Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-22 : 20:18:05
|
John writes "I wrote a SQL statement that should query the Order database and retrieve records which have a blank in the invoiced date field. My only problem is do i use null, even though that doesn't mean pulling a blank record, or is there another term to use in SQL that looks for particular blank fields and retrieves the record. Here is my SQL so far:
if Request.Form("Order") = "OrderDate" then
SQL = "Select * FROM Order a, Appraisr d, Clients c Where a.InvoicedDate = {not null} and a.AppraiserCode = d.AppraiserCode And a." & Request.Form("Order") & " >= {" & Request.Form("SD3") & "} " & "AND a." & Request.Form("Order") & " <= {" & Request.Form("SD4") & "} and a.Clientcode = c.Clientcode "
end if
thank you,
john" |
|
|
|
|
|
querying a database for blank fields...