Professional Web Applications Themes

InStr, substr, Mid ??? - ASP

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 [url]http://www.developersdex.com[/url] *** Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default InStr, substr, Mid ???



    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 [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    J. Muenchbourg Guest

  2. #2

    Default Re: InStr, substr, Mid ???

    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" <jodaddycanada.com> wrote in message
    news:eXx2RoSYDHA.4040tk2msftngp13.phx.gbl...
    >
    >
    > 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 [url]http://www.developersdex.com[/url] ***
    > Don't just participate in USENET...get rewarded for it!

    Alan Guest

Similar Threads

  1. php equivalent to asp's instr()
    By Dvdmandt in forum PHP Development
    Replies: 2
    Last Post: February 5th, 09:10 AM
  2. advice on how to handle INSTR search?
    By bobmct in forum MySQL
    Replies: 0
    Last Post: June 9th, 05:23 PM
  3. INSTR function and case sensitivity
    By D Woods in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: March 14th, 06:36 AM
  4. [PHP] substr ?
    By John Taylor-Johnston in forum PHP Development
    Replies: 0
    Last Post: August 17th, 05:49 AM
  5. how to print instr ptr from stack in signal handler?
    By Chris Markle in forum UNIX Programming
    Replies: 0
    Last Post: August 1st, 03:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139