Posted on 2014-01-23
I need some help with creating a sql statement that can be used with html page. I need to pull data from a field within table and show the results as either yes or no
I have two types - one is a date field and the other is either 1 or 0. The one giving me a problem is the date - the default for the field is 1/1/1900 so I need to show any with this date as no and any with a date other than this as YES. I hope has enough information for someone to help me if not please let me know. I have tried this basic statement and customizing for my data and using a date but keep getting errors.
Select Case When IsNull(FieldName, 0) = 1 Then 'Yes' Else 'No' End As FieldName From TableName