Q&A BY TAG 'Like'

I am running this code on a Denodo database, SELECT TRUNC(tran_dttm) as dt, substr(device, 1, 3) AS tech, SUM(out_qty) AS moves FROM database.table WHERE facility IN '****' and device regexp_like '^P.*' AND tran_dttm >= DATE '2020-09-26' AND tran_d...

NOT LIKE REGEXP_LIKE Like

Hello, I am running into an issue when using the LIKE operator on my webservice. In order to make the like more effective, I have added a percent sign before and after the text I want to search on. This way I can bring back results that have my text a...

REST search Like Filter encoding URL Web Service

I have an input parameter, p_subst_name, defined for a view, which I would like to use in the where clause as follows: view1.subst_name like %p_subst_name% what would be the right syntax for this please ?

Like