How to check the last two digits?

Question

SUBBIS
SUBB1D
SUBBD3
SUBB12

In above values, how can I check the last two digits (IS, 1D, D3, 12) are numbers using a sql code?

Answer 1

Do you mean to fetch those values? You can do that with like:

where column like '%[0-9][0-9]'

If you need to ensure that the values always end with 2 numbers, you can do it with similar check constraint.