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