Hi all,
I have a question concerning labelling OSM data.
I want to label the US interstates (from the OSM data), where I use the following Sql statement:
SELECT * FROM roads WHERE
"fclass" = 'motorway'
and "ref" LIKE 'I %%%'
This statement gives me the interstates (see attachment), but I dont want to include the I in the symbology. Does someone know a way to exclude the I in the symbology? I guess this can be solved by editing the sql statement?
Thanks in advance.