@CodyPatterson
I am still having trouble. The SQL you have looks perfect for regular SQL statements, but is complaining when I try to create a definition query or select by attribute 😞
This works:
CONCAT(ST_NAME, LOCATION) = ROUTE_NUM
This does not work when I try to add a space:
CONCAT(ST_NAME, ' ', LOCATION) = ROUTE_NUM
Thank You