


Hi,
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 ?
Thanks,
Salvatore
Views
Replies
Sign in to like this content
Total Likes
Hi Salvatore,
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.
Reminder: the SQL expression syntax is not the same than regex syntax (used in Javascript or other development languages).
Regards
J-Serge
Views
Replies
Sign in to like this content
Total Likes
Hi Salvatore,
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.
Reminder: the SQL expression syntax is not the same than regex syntax (used in Javascript or other development languages).
Regards
J-Serge
Views
Replies
Sign in to like this content
Total Likes