Try NAME NOT LIKE '% ISLAND' The % needs to be used with LIKE or NOT LIKE in SQL
- sent via mobile iOS5 On 2013-02-06, at 4:58 PM, sidecar5 <shoemark.pe...@gmail.com> wrote: > Team, I have a data set that has a colmn 'NAME' that includes a bunch called > '?????? ISLAND' > > I am trying to exclude the ISLAND tags by using (NAME <> '% ISLAND') without > brackets as my filter but it does work. > > any helpers plz or a page where I can get basic examples?? > > I'm ,more than comfortable with normal sql selct * from ? where !=?? etc. > > Cheers, Peter > > > > -- > View this message in context: > http://osgeo-org.1560.n6.nabble.com/Filter-query-problem-tp5032605.html > Sent from the MapGuide Users mailing list archive at Nabble.com. > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users