How can I find the correct row when the variable is one character that exists within the field and the field is many characters?
c.gpatypes = OMCG
@gpatypec = 'M'
normally I would find the row with:
select * from c where gpatypes like '%m%'
but the function isn't working with
gpatypes like '%@gpatypec%'