Mike:
You will need to have some kind of structure in that string if you want to successfully parse it. However, as we do not know what variations you can have, I can't say whether LEN() would be good. The use of LEN() would assume that you do have part of the string in some other form. Your best bets are a combination of SUBSTR(), SPLIT() and INSTR()/INSTRREV() to separate the strings into their components. you will also have to take care of cases line spaces in usernames or filenames or foldernames.
If you would post a list of potential strings then we might be able to help you more.
[ 08. January 2003, 23:16: Message edited by: sealeopard ]
_________________________
There are two types of vessels, submarines and targets.
