AnsweredAssumed Answered

Definition Query to find where first character = 'XYZ'

Question asked by ben_vk on Feb 6, 2017
Latest reply on Feb 7, 2017 by rfairhur24

Hi All, 


Just wondering if there is an easy way in the Query Builder to create a definition Query where the attributes first character starts with X??


Just for an example, in the below screenshot how would one create a query to return all features where the Feature_Type starts with the letter 'Y'?? At this stage it would only show YARRAMBA CRES. and YARRUNGA.


I was thinking something like using LEFT(FEATURE_TYPE,1) = 'Y' but this is invalid, I am assuming there is some other easy way that I cannot think of at 5pm in the afternoon!


sql definition query.


Any suggestions?