Is there any way to make a single SQL ... FROM statement using source data that's known to have flaws. Back to the OP - either filter out the bad records in the WHERE clause, or put a CASE ...

I have included a sample function in Listing A for conversion from the Orace decode statement to the SQL Server case statement.