Hi Andrew,
Try using the NOT outside the IN operator
*NOT "tag_service" IN ('alley', 'drive-through', 'driveway', 'laneway',
'parking_aisle', 'parking')*
Alexandre Neto
User support
www.qcooperative.net
A quinta, 15/07/2021, 08:19, Andrew Hughes <[email protected]> escreveu:
> Thanks Marco,
>
> You've answered my question, so thank you. For reference, I've never see
> this in any sql rmdbs.
>
> Some examples my help the community, hopefully I will be able to
> contribute sooner or later.
>
> Thanks again!
> Andrew
>
>
> On Wed, 7 Jul 2021 at 17:43, GMAIL <[email protected]> wrote:
>
>> This is how sql works.
>> You want to apply a function to one column, and the column you are
>> comparing must have a value.
>> Consider this: tag_service != 'xxx' or null != 'xxx'. Null can't be
>> equal or unequal to any value. Even null = null or null != null returns
>> false
>>
>> hth
>> marco
>> _______________________________________________
>> Qgis-user mailing list
>> [email protected]
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
> _______________________________________________
> Qgis-user mailing list
> [email protected]
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
