I am using SQL Server 2008
I have a numeric field in the following format: yyyymmdd
I wish to convert to date in this format: mm/dd/yyyy.
However, sometimes the field contains values that cannot be converted to dates. (examples: 0, 99999999). I wish to have these values come through as empty value.
How can I accomplish this?
Thanks for any help.