Subject Re: String manipulation in Stored Procedures
Author Adam
> 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?

You can adapt this to your needs: