I would like to exclude all those deliveries belonging to MESSAGE CENTER with internal name that ends with "_rt"
I cannot use the expression "CONTAINS '_rt' " because I will get also "notifyStockAlert" for no reason so I am forced to use a regular expression, something like "LIKE '*_rt' "
Could you tell I should I write this regex ?
Jochem van Dieten
Take care, in SQL expressions / SQL RDBS engines, most of time the wildcard specials chars are:
% (and not *) for strings
_ means 1 char to replace
so _rt means art, brt, crt, etc. So the "StockAlert" matches it.
To use the _ sign you must escape it, usually \_ but the syntax may depend on the SQL engine.