[firebird-support] Get records based on the third portion of a version string

[venussof...@gmail.com [firebird-support]]

Hi all

I was wondering if there was a way to get a portion of a string based on a 
separator character.  What I needed to do was want to bring out a part of the 
version number.

1.23.456.789

I want to get just the third portion, 456.  So I could query on strings that 
have a version number with the third portion less than or equal to 456.  Thus 
all records which may contain

1.1.55.0
1.15.450.688

Hope I was able to explain.

Please advise.

Thanks and regards
Bhavbhuti