Database contains products table

id id_as_num description
AAA000 000 —
BBB111 111 —
CCC222 222 —

Some users have there own article id’s with another prefix.
Lets say prefix YYY.

I thought a query like underneath would give a match:

SELECT * FROM products WHERE “YYY“+id_as_num LIKE “%YYY111%”

Is there no way to do a select criteria on a field as if there is a string added to it?