I have some sql that I have been trying to develop , but I have run into a little snag. I have included the offending part of the sql statement according to 05 sql server mgmt.
The issue is basically with the like statment with multiple values. I have searched and have not found any informaition on this issuue.
PAYER_CATEGORY =
CASE
when (oins.short_name not like '%medicaid%', '%medicare%' '%paid%' '%cash%') then '01'
when (oins.short_name like '%medicare%') then '02'
when (oins.short_name like '%medicaid%') then '03'
when (oins.short_name like '%cash%', 'paid%') then '04'
else '05'
end,
Start Free Trial