Subject String manipulation in Stored Procedures
I am attempting to break a string with 3 components, seperated by .
(period) characters, and convert each component to an Integer value.

For example, if I have a string like this:


I want to break it into

Part A = 1
Part B = 0
Part C = 119

I need to do this in a stored procedure in Firebird.

Are there any equivalents to PHP's 'Explode' function that does this sort of
thing, or some call that will search for the location of a character so I
can do a substring on it to get the component part?


Myles Wakeham
Director of Engineering
Tech Solutions USA, Inc.
Scottsdale, Arizona USA
Phone +1-480-451-7440

Try our new Outlook Utility 'Split Personality'