find specific strings or number in SQL using case when and CAST function

PHOTO EMBED

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 
content_copyCOPY