Mon Apr 25 2022 04:32:02 GMT+0000 (Coordinated Universal Time)
Saved by @Bambibo9799
--convert the phone data type into text to find specific numbers select *, case when phone::text ilike '435%' or phone::text ilike '%233%' or phone::text ~ '23' then 'yes' else 'no' end as test from x_csv as xc
Copy this HTML code:
Preview:
open_in_newInstructions on embedding in Medium
Comments