Maybe something like

SELECT CASE Marital_Status IS NULL OR Marital_Status =SPACE(1) then "M" Else Marital_Status end from <your table>

>Hi everybody,
>
>I have a field in my database for a Marital Status. I want to return 'M' if it's null or empty and the status otherwise. What would be the best implementation?
>
>Thanks in advance.