Where clause

• Keyser Sozay

  SSC Veteran

  Points: 214

  More actions

  April 13, 2004 at 8:03 am

  #110839

  Hi all, a simple one I hope:

  I'd like a query that checks for the inclusion of a value:

  SELECT *

  FROM JS20040408

  WHERE field2 CONTAINS XXXX

  Field2 MIGHT contain a value before, after, or on both sides of xxxx.  I need to return all rows containing xxxx, regardless of whatever other data is in the field as well.

  I thought about 'Like' with the %, ie. Like %xxxx%, but can't verify it on a system yet.

  Thanks,

   

  KS.

   

• fhanlon

  SSChampion

  Points: 13131

  More actions

  April 13, 2004 at 8:18 am

  #502568

  Your correct.  Like %xxxx% will retrun all rows with xxxx in that column regardless of where in that column its found.

  Francis

• Keyser Sozay

  SSC Veteran

  Points: 214

  More actions

  April 13, 2004 at 8:31 am

  #502574

  Thanks!

   

  KS