Parse date from _table_suffix

Question

I want parse date from _table_suffix for execute last date in table names, but i can't to do it. Firstly, i select just like

After parsed dates me saw a mistake about parse string with '..x' in the end.

What function will be solve for problem ? Where are from '...x' ???

I maybe can select max date from all tables, but each table can have next day after report day in name of table. So i want solve problem only with table suffix.

Answer 1

I delete table with '...x' and can check my query. So, u can try check last table_suffix in your wildcards =)