Get string ending with zero or more digits

Question

I am trying to write a query which returns string ending with zero or more digits.

For example, I have strings 'amit', 'amityy', 'amit001'. I want to only return 'amit' and 'amit001'.

I tried LIKE 'amit%', but not get success.

Answer 1

Checks if the string starts with amit and that there are only numbers after amit:

LIKE 'amit%' AND NOT LIKE 'amit%[^0-9]%'