I have an SQL query that I cannot get it to work. Maybe I really don't know the logic. I know this is just simple to the experts.
The case statement is supposed to get if Col4 = CHK in Col0 = AA and Col0 = BB and Col2 like '%000888888%' then 'ACH' but my query did not output what I need.
Here's the query I have and My Query Output attached:
WHEN ([Column 2] LIKE '%000888888%'
AND [Column 0] = 'BB')
END AS [Col4NEW]
ORDER BY UniqueID ASC
Please see attached file for more info.
Thank you again and again for all the help.