[mapguide-users] Filter query problem

[Ryan Northcott]

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.peter at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users