I need a text string to filter those that contain the following format:
SELECT Referencia FROM A
WHERE Referencia LIKE '%[78][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]%'
Where the 78
is a fixed number and I need exactly 8 numeric characters to follow it.
String Example:
PLANO-7800002154_asdvd0.pdf
TOMO_1800015711.pdf
2016032213_Campo_AS.pdf
I just want the one with 78XXXXXXXX back
And then get just that string of numbers.