Searching for (_) in a column data.

• Deviprasad

  Ten Centuries

  Points: 1060

  More actions

  April 9, 2009 at 12:52 pm

  #203361

  Hi All,

  Reference:

  I want to write a query to display all the row which contains an (_) underscore.

  and the update all records that fall under this criteria in the same statement.

  If the data is name1_a ,name2_b, name3_c, after i run the statament my resultant data shuold be

  name1 ,name2, name3

  Thanks

  Dev

• GSquared

  SSC Guru

  Points: 260824

  More actions

  April 9, 2009 at 12:55 pm

  #975357

  Please don't double-post.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• Deviprasad

  Ten Centuries

  Points: 1060

  More actions

  April 9, 2009 at 1:40 pm

  #975392

  Reposted with a different question