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