Filter with Wild Cards

[RPYee]

I have some location codes that may be 3 characters or 5 characters.  Regardless of how many characters, I need a filter set that will return all location codes that begin with the letter "Y".  I've tried 'Contains Y%', with no results.  Can someone suggest the correct syntax? 

Thanks, in advance, for your help!

Rita Yee

Project Engineer, FedEx Express

[WarrenKuhfeld]

In what context are you asking?  This will work in some contexts:

code =: 'Y'

[FredrikE · Accepted solution]

Try:

upcase(substr(locationCode,1,1)) = 'Y'

Use it in an advance filter 🙂

//Fredrik

[RPYee]

Worked perfectly!! Thanks so much!