https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-with-Wild-Cards/m-p/398974#M25640 <P>In what context are you asking? &nbsp;This will work in some contexts:</P> <P>&nbsp;</P> <P>code =: 'Y'</P> Tue, 26 Sep 2017 23:39:51 GMT WarrenKuhfeld 2017-09-26T23:39:51Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-with-Wild-Cards/m-p/398968#M25639 <P>I have some location codes that may be 3 characters or 5 characters.&nbsp; Regardless of how many characters, I need a filter set that will return all location codes that begin with the letter "Y".&nbsp; I've tried 'Contains Y%', with no results.&nbsp; Can someone suggest the correct syntax?&nbsp;</P><P>&nbsp;</P><P>Thanks, in advance, for your help!</P><P>Rita Yee</P><P>Project Engineer, FedEx Express</P> Tue, 26 Sep 2017 22:12:13 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-with-Wild-Cards/m-p/398968#M25639 RPYee 2017-09-26T22:12:13Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-with-Wild-Cards/m-p/398974#M25640 <P>In what context are you asking? &nbsp;This will work in some contexts:</P> <P>&nbsp;</P> <P>code =: 'Y'</P> Tue, 26 Sep 2017 23:39:51 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-with-Wild-Cards/m-p/398974#M25640 WarrenKuhfeld 2017-09-26T23:39:51Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-with-Wild-Cards/m-p/399046#M25652 <P>Try:</P> <P>upcase(substr(locationCode,1,1)) = 'Y'</P> <P>&nbsp;</P> <P>Use it in an advance filter <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P>//Fredrik</P> Wed, 27 Sep 2017 06:39:27 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-with-Wild-Cards/m-p/399046#M25652 FredrikE 2017-09-27T06:39:27Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-with-Wild-Cards/m-p/399164#M25659 <P>Worked perfectly!! Thanks so much!</P> Wed, 27 Sep 2017 13:44:25 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-with-Wild-Cards/m-p/399164#M25659 RPYee 2017-09-27T13:44:25Z