I have a query like the following:
Now, the people that designed the database have NULL values EVERYWHERE! It's a complete mess that I have to deal with. For some ungodly reason, someone's hire date is NULL. I know, makes no sense. Why would this person have a record if they don't work for us and don't have a hire date?Code:"SELECT " & _ [last_name]," & _ [first_name]," & _ [hire_date]," & _ "FROM vw_people " & _ "WHERE id = @id"
Anyway, is there a way via my above query to return a default date if "hire_date" is NULL? I'm using SQL Server 2000. This is a hard coded query unfortunately and I'm not sure if I can do some sort of SELECT CASE here.



LinkBack URL
About LinkBacks
Reply With Quote


. Obviously sumpin' gotta change sumplace, so which would you like to do:
Bookmarks