Category "firebird2.5"

Select only digits from Text

Anyone can help how can I select only digits from Text? Strings can be random like: ABCD123DEF -> Result must be 123 393SEA981F -> Result must be 393981

run a query using EXECUTE BLOCK to prepair a column for an unique-Index

I have a column in a table that I want to use for an unique-index. My script should make the data unique by concat the id of a record, if the data of current re