Wildcards within an IF statement in a Script

[Anonymous]

Hi everyone,

I multiple IF statements for data scrubbing purposes.  I've tested one but when I use a wildcard it just doesn't work. It seems to ignore it or it tries to literally search for the asterisk within the field data. I also tried % character for a wildcard. No luck.

If ([Make] = 'Mercedes', 'Mercedes Benz', [Make])

If ([Make] = 'Mercedes*', 'Mercedes Benz', [Make])   (doesn't work)

[#2]

How about:

IF(SUBSTRINGCOUNT(UPPER(MAKE),'MERCEDES') > 0, 'Mercedes Benz', Make) AS ...