3

I have a BUILDING.SHP and in the attribute table, it has several names and some of the attributes are "STOR" and "MULTIPLE-STOREY CAR PARK" like image below.

enter image description here

enter image description here

In my map, I don't want label the records that say "STOR" or that contain "STOR" like "STOR BARANG".

In my SQL Query, I have used (NAME NOT Like '%STOR%') however the MULTI-STOREY CAR PARK also disappeared.

Is there any other query that can I use?

4

Using a LIKE statement will return any string containing the search terms - in this case "STOR". I believe you are looking to only filter out names that are specifically "STOR".

In that case simple using NAM <> 'STOR' should do the trick.

To exclude labels like "STOR BARANG" and "STOR" but still include "MULTIPLE STOREY CAR PARK," use NAM not like 'STOR%'.

  • i used the query (NAM NOT Like '%STOR%')because, if in the attributes have features name like STOR KAYU, STOR BARANG or anything that have STOR in their name, i must not label it. i try to use the query NAM<>'STOR' but it only not label the 'STOR'. – abc Apr 6 '15 at 3:45
  • 4
    DID you consider not like 'STOR%' – FelixIP Apr 6 '15 at 4:35
  • 1
    I already try(NAM NOT LIKE'STOR%')and its work..thank you so much.. – abc Apr 6 '15 at 6:41
  • @user If this answer solved your problem, please click the checkmark to mark it as "answered." – Sara Barnes Apr 6 '15 at 20:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.