I am attempting to execute a Select query in Select By Attributes where the return record set I'm looking for includes all records where the String value is greater than 7 characters long.
For ex., I have records in my table where the value in the "LeftCityCo" field is 2395187, and other records where the value in the "LeftCityCo" field is 2395934ANO. I'm seeking to obtain a Selection that includes all records with values in this field greater than 7 characters long.
I've tried using the Left function and attempted the following query but returned an error:
Select * From Streets Where
"LeftCityCo" = Left( "LeftCityCo", 7 )
WHERE Length("LeftCityCo") > 7
CHAR_LENGTH("LeftCityCo") > 7