> 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:

http://www.fbtalk.net/ViewTopic.aspx?id=154

Adam