Re: [firebird-support] SELECT IN wildcard

2019-12-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 14/12/2019 06:13, Hugo Larson hugo.lar...@yahoo.com [firebird-support] wrote: > Is it possible to use wildcard somehow like this. > > SELECT * FROM PRODUCT > WHERE PRODUCT.ID IN (:param) > > param will be a list or IDs or a wildcard. > % does not work. > Goal is to get all PRODUCT with wildca

[firebird-support] SELECT IN wildcard

2019-12-13 Thread Hugo Larson hugo.lar...@yahoo.com [firebird-support]
Hello, Is it possible to use wildcard somehow like this. SELECT * FROM PRODUCTWHERE PRODUCT.ID IN (:param) param will be a list or IDs or a wildcard. % does not work. Goal is to get all PRODUCT with wildcard :param Thanks, Hugo Larson