Another definition query question. My point shapefile contains a string field ("Tag") populated with values:
'AdHoc'
'AdHoc[followed by ref numbers]'
'Adhoc'
'Adhoc[followed by ref numbers]'
'TreeSurv'
etc. etc.
I wanted to split the layer so one only displayed points where the "Tag" field contains only AdHoc/Adhoc values.
"Tag" LIKE 'AdHoc%' found all these values but it missed out 'Adhoc'. Ok so it's case sensitive this query business. So...
"Tag" LIKE 'AdHoc%' AND "TAG" LIKE 'Adhoc%' BUT this returned no results.
What am I doing wrong here?