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?

 

 

Outcomes