Hi Bob, welcome to the forum.
Perhaps provide some sample data and your expected results.
Also note that the FIND function is case-sensitive, while SEARCH is not. FIND also doesn't allow wild-card usage, while SEARCH does.
Finally note that if it does find "acct_num", the position returned will be that of the first character in "acct_num". So instead of adding 1 to the FIND, add 8 to get to the first character after "acct_num".
Bookmarks