Skip to Content
0
Aug 31, 2023 at 02:15 PM

match regex as like operator

45 Views

Hello,

I need a little help with match_regex when joining tables in DataServices

i am trying to achieve this from SQL
select * from a join b on a.id = b.id and a.number LIKE b.number + '%'

so i am trying to achive this in march_regex but instead value i need to use column, so something like this:

match_regex(a.number,b.number, NULL)=1

how to add this % sign to second argument?