simple query question

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Erik Summers

    simple query question

    Need some help in a hurry, thanks to all.
    need to query one text element out of a longer string... i.e.:
    query the word "dance" from a data similar to the following.

    karate,baseball ,ballroom dance,polo,bask etball


    I know I can use '$variable%' to search a wildcard, but it appears
    that only works if the variable exists in the begining of the string.
    I need a way to query a word ANYWHERE within the string.

    Thanks for any help.

    E
  • JAS

    #2
    Re: simple query question

    Erik Summers wrote:[color=blue]
    > Need some help in a hurry, thanks to all.
    > need to query one text element out of a longer string... i.e.:
    > query the word "dance" from a data similar to the following.
    >
    > karate,baseball ,ballroom dance,polo,bask etball
    >
    >
    > I know I can use '$variable%' to search a wildcard, but it appears
    > that only works if the variable exists in the begining of the string.
    > I need a way to query a word ANYWHERE within the string.
    >
    > Thanks for any help.
    >
    >[/color]

    '%$variable%'

    Bingo!

    J

    Comment

    Working...