CONTAINS KEYWORD

• tantan1208

  Valued Member

  Points: 61

  More actions

  July 28, 2005 at 4:49 am

  #90335

  Hi there.  I'm trying to use the contains keyword but i just can't understand why it's not returning a record when i use CONTAINS(*, ' "part 11"') but when i use CONTAINS(*, ' "part*"') or CONTAINS(*, ' "11*"') it returns the record.

   

  Many Thanks

   

• venku009

  Mr or Mrs. 500

  Points: 503

  More actions

  August 1, 2005 at 1:11 am

  #578424

  Try trimming i.e. RTrim