Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif
IT KNOWLEDGE IS APPLIED KNOWLEDGE So Just Do It
SELECT NULLIF(yourDateColumn, '01-01-1900') -- returns NULL
Login to post response