I have a table that contains a date column (type date), and I want to return all rows but if the date = 1900-01-01, I want it to display NULL or blank. But if it is any other date return the date value.This is what I have so far? Perhaps there is a better way of doing this? I'm getting the following error"Conversion failed when converting date and/or time from character string."Select FirstName, LastName, Salary, CASE CAST(StartDate as CHAR) When '1900-01-01' Then 'NULL' Else StartDate ENDFrom HR_test
Thanks for the help!!
Help with SQL query
Posted - 2010-10-13 : 17:47:53
