InStr, substr, Mid ???

Discussion in 'ASP General' started by J. Muenchbourg, Aug 13, 2003.

  1. 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 ***
    Don't just participate in USENET...get rewarded for it!
     
    J. Muenchbourg, Aug 13, 2003
    #1
    1. Advertising

  2. J. Muenchbourg

    Alan Guest

    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

    "J. Muenchbourg" <> wrote in message
    news:...
    >
    >
    > 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 ***
    > Don't just participate in USENET...get rewarded for it!
     
    Alan, Aug 13, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Kathy Burke
    Replies:
    0
    Views:
    416
    Kathy Burke
    Nov 24, 2003
  2. =?Utf-8?B?cm9kY2hhcg==?=

    InStr test

    =?Utf-8?B?cm9kY2hhcg==?=, Nov 7, 2006, in forum: ASP .Net
    Replies:
    12
    Views:
    619
    =?Utf-8?B?cm9kY2hhcg==?=
    Nov 15, 2006
  3. Replies:
    1
    Views:
    3,471
    Victor Bazarov
    Jul 13, 2005
  4. Graham Mattingley

    InStr Help

    Graham Mattingley, Nov 10, 2003, in forum: ASP General
    Replies:
    4
    Views:
    159
    Chris Barber
    Nov 10, 2003
  5. Joey Martin

    SECOND instance in instr

    Joey Martin, Jul 7, 2004, in forum: ASP General
    Replies:
    6
    Views:
    141
    Mark Schupp
    Jul 7, 2004
Loading...

Share This Page