I'm trying to search a specific pattern using LIKE operator, but i'm not sure if i'm doing the right way.
MY cloumn values are ABC_INFO_Calc, ABC_CALC_PRO, ABC_201501, ABC_201412.
I would like to slect the last two values and any value matching that (ABC_201501, ABC_201412).
I'm trying something like this
where table_name like 'ABC_[0-9]%'
But no results while i run the query.
Can anyone help me with the parsing pattern in Teradata.