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:

1.0.119

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

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

Try our new Outlook Utility 'Split Personality'
http://splitpersonality.techsol.org