Q:

SQL Query in arcmap

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.

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?

A:

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%'.

