LIKE witout spaces

• Totti

  SSC Rookie

  Points: 38

  More actions

  October 25, 2006 at 3:45 am

  #67762

  Hey all i have a query much like this

   

  SELECT * FROM tbl_test

  WHERE testname LIKE '%Jay%'

  this works..it selects the user Jay if i type in jay but if i type in 'Jay ' with a space the query doesnt work..any ideas on how i can solve this ??

• ijaz

  SSCommitted

  Points: 1912

  More actions

  October 25, 2006 at 5:41 am

  #667809

  hi,

  used the builtin funtions LTRIM, RTRIM to trim the extra spaces on the left or right side.

  hope this will slove your problem

  thanks

  ijaz

  cheers

• debrucer1

  SSCertifiable

  Points: 5366

  More actions

  October 25, 2006 at 6:44 pm

  #668060

  but beware of that leading %... causes full scan of table.

  Thank-you,
  David Russell
  Any Cloud, Any Database, Oracle since 1982