How to write for numbers search in LIKE operator

Hi All,

I am using below search on string data types , it was working. But integer data types keys, search with LIKE operation not working.


select * from YYY_BUCKET where _type=“Devices” and device_type like “Metr%”

I need to search store_number LIKE 99%, how do write query in number types?


LIKE is meant for string search. You need convert number to string then do search.

TO_STR(store_number) LIKE "99%"

1 Like

Thanks for the solution @vsr1