Posted on 2009-07-12
Hello - I'm having trouble setting up a formula for a computed column in SQL Server 2000
I want to have a literal ">" with a particular date field when that date field contains a null. In the "Formula", tried: CASE WHEN ISDATE(MyDateField) THEN '' ELSE '>' END
but this gets a syntax error.
(Doing this as a computed column in the table is a lazy fall-back to just doing it as an expression in a View, because the View Deigner in Enterprise Manager does not support CASE statements. If there is a better way, please tell me)