Searching Text Fields

• Chris Gilbert

  SSC Enthusiast

  Points: 191

  More actions

  January 26, 2004 at 2:53 pm

  #177849

  How do I search a particular field for a given string? For instance if I have a productDescription field, that contains a 30 word description of a particular Car for example, how would I search for the word RED or AIR CONDITIONING etc? I assumed that I could use fairly simple SQL and ASP to search for a word or phrase but all attempts to find the syntax appear to suggest its not possible???

  Thanks for your help,

• dchilton

  SSC Veteran

  Points: 293

  More actions

  January 27, 2004 at 6:57 am

  #491749

  Try using the InStr function. 

• Kathi Kellenberger

  SSChampion

  Points: 11811

  More actions

  January 30, 2004 at 7:15 pm

  #492429

  You can also use LIKE:

  Select * from myTable where myTextField like "*red*"

  Or in SQL Server

  Select * from myTable where

  myTextField like '%red%'

  Aunt Kathi Data Platform MVP
  Author of Expert T-SQL Window Functions
  Simple-Talk Editor