InStr, substr, Mid ??? -- inetserver asp general

J. Muenchbourg
8/12/2003 4:32:59 PM

I have a field name "tracks" of string data type that has multiple names
in it (for example: calder delaware$ aqueduct ), and I want to check to
see if this certain field has "delaware$" in it. InStr or the Mid
functions return the numerical order of where that string starts inside
the string, but it doesnt tell me if "delaware$" exists in "tracks".

????
Muench

*** Sent via Developersdex http://www.developersdex.com ***

Alan
8/13/2003 12:18:42 PM

If (Instr(1, tracks, "delaware$", vbTextCompare) <> 0) Then

' delaware$ is in the string

End If

Just watch out for other return values from Instr - check MSDN.

Cheers,

Alan

[quoted text, click to view]

inetserver asp general : InStr, substr, Mid ???