Suggestions so far involve traversing the string twice, which may be nasty for really long strings.
String searches are quick; it's manipulating strings which cause them to be copied which are much slower.
The POS = INDEX(X,"AC",COUNT(X,"AC")) method is probably fastest. Stewart -- Stewart Leicester | JenSoft Technologies, LLC "Per Ardua Ad Astra" | ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
