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?