MasterChief wrote:
I have a Drop Down box that is being populated using the SQL Distinct
command. How do I get it so it doesn't show Null values?
Here is my SQL statement
sSQL = "SELECT DISTINCT Title FROM Everyone ORDER BY Title ASC"
It depends. If you simply want to exclude Null values, then use a WHERE
clause:
sSQL = "SELECT DISTINCT Title FROM Everyone " & _
"WHERE Not Title IS NULL ORDER BY Title ASC"
If you want the Null value replaced by some text, then the answer depends on
the type and version of database you are using (please don't forget to
include that information when asking database-related questions - it is
almost always relevant)
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"