Find X in a Number String 1

[jcmv007]

USING:
Windows XP SP1
Access 2002 SP1

What function or code can I use to find for example, 1 in the following string: 8,1,9,11,23 ?

 

[SgtJarrow]

InStr(1, String, "1&quot

will give you the location of the first occurance of the second arguement in the first string...in this case:

Instr(1, "8,1,9,11,23", "1&quot

would return 3

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[jcmv007]

mstrmage1768,

It worked great Thanks!