Munabhai (9/1/2015)
If I use, as following, it won't throw error, but it will display 0 instead of blank.WHEN ISNULL(date1, '1900-01-01') = '1900-01-01' THEN ''
Please learn to be consistent in your coding. In your OP you use #TEMP and #temp interchangeably. This works in a case insensitive environment but fails in a case sensitive environment. Being consistent demonstrates you care about the code you write and that your code will run in either environment.