How to Handle NULL value in SQL server 2005

To handle NULL value in the sqlserver 2005

By using ISNull function you can handle null value
SELECT @BeginDate = ISNull(@BeginDate, '1900-01-01')