2 Replies Latest reply on Aug 21, 2007 4:04 AM by KeithLaw999

    where column find in string

    KeithLaw999
      Gday,

      wonder if someone can help?
      i have a url string which looks like this

      page.cfm?from=888888888&text=I+faxed+a+note+2day+4+Aaron

      i have some code that replaces the + symbol with a space.
      i need a query to matches records by the column "NUMBER" to the "from" parameter and if my column "FIRSTNAME" appears in the string "text"

      ie WHERE "Aaron" matches Aaron in the string.