Replacing Nulls with a temp value. 1

[iaresean]

Hi All;

I am trying to do date between select on a table that has startdate and enddate columns, however, a problem I am having is that some records have a 'NULL' enddate. These records signify 'never-ending' events.

Is there any way for me to assign a value (like '2099/01/01') to these null enddates for the duration on my query? I am aware of a method of creating a temptable first and then updating the endates within this table, however, I would like to know if I could satisfy my requirements with a single select statement.

Thank you for any and all help!

Sean.

 

[SQLDenis]

use COALESCE

select COALESCE(Columname,'2099/01/01')
FROM YourTable

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[iaresean]

Thank you.

Sean.