Dear Colleague
This works (returns 12345):
select substring('ABC 12345 XYZ' from '%#"[0-9][0-9][0-9][0-9][0-9]#"%' for '#') as found_5_digits;
While this fails (returns blank):
select substring('ABC 12345 XYZ' from '%#"[0-9]{5}#"%' for '#') as no_5_digits;
Am I misunderstanding the documentation on using [0-9]{5} or do you think it's a bug?
TIA
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Barry Brunning | Data Stream Pty Limited | p/f. +612 9982 3550 | w. http://www.datastream.com.au