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)