|Subject||Re: String manipulation in Stored Procedures|
> I am attempting to break a string with 3 components, seperated by .sort of
> (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
> thing, or some call that will search for the location of a characterso I
> can do a substring on it to get the component part?You can adapt this to your needs: