Wildmatch "LEFT"

[AnnaEKinch]

Hi!

I want to get data but non- case sensitive.

In my script below I only get case-sensitive data ie only posts with 'u0' or "EMW". But I need all posts irrespective of case. I figured it should be possible using WILDMATCH but I can't get my head around it. Anyone can help?

If (left("NOTE_TEXT",3)= 'EMW', 'In progress',

If ((left("NOTE_TEXT",2)= 'u0'),'In progress',

[jbhappysocks · Accepted solution]

Hi, use Upper

If (upper(left("NOTE_TEXT",3))= 'EMW', 'In progress',

If ((upper(left("NOTE_TEXT",2))= 'U0'),'In progress',

[AnnaEKinch]

Wonderful! Smart! Thank you soooo much!