Like Statement

• Carly Simpson

  Newbie

  Points: 1

  More actions

  April 13, 2005 at 3:45 am

  #88681

  Is there anyway in which I can use the like statement to search for a whole word with spaces before and after?

  i.e. I am currently using the following

  WHERE description LIKE '%arco%'

  but this brings out lines with charcoal in them.  What I would like to look for it where arco appears on it own so

  WHERE description LIKE '% arco %'

  but this doesn't work.

  Can anyone help?

  Regards

  Carly

• Meghana

  SSC Eights!

  Points: 830

  More actions

  April 13, 2005 at 4:04 am

  #552342

  you can do something like this

  where Description LIKE '% arco%' or Description LIKE '%arco %'

  HTH

  Meghana

  ---

  Regards,

  Meghana
  

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  April 14, 2005 at 2:31 am

  #552627

  use tempdb

  create table #test

  (

   c1 varchar(10)

  )

  insert into #test values('charcoal')

  insert into #test values('c arco l')

  select * from #test where c1 like '%[ ]arco[ ]%'

  drop table #test

  c1        

  ----------

  c arco l

  (1 row(s) affected)

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]