Searching for element's position

Since the whole purpose of all this is to make sure there are 6 digits in front of the underscore, you could also treat the string as a list and use the underscore as a delimiter ... then just use Len on the first entry in the list to figure out the length.

i.e.
MainString = "123456_SP00932"
PrefixLen = Len(ListGetAt(MainString,"1","_"))

<CFIF PrefixLen EQ 6>
number is OK
<CFELSE>
number is not 6 digits
</CFIF>

There are 2 functions you can use: Find() or FindNoCase(), but since you are looking for "_", Find() should be sufficient enough.

For example:

"123456_SP00932"<br><br>
<cfset StrToFind = "123456_SP00932">
<cfset StrToFind = Find("_", Trim(StrToFind), 1)>
<cfoutput>
<cfif StrToFind eq 7>
"_" is in position 7
<cfelse>
"_" is in position #StrToFind#
</cfif>
</cfoutput>

find()
if you do not know the correct syntax for it, look in the CFML
Reference. if you do not have one - download from Adobe website

---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com