Update Query

• Whizkid

  Right there with Babe

  Points: 783

  More actions

  March 12, 2007 at 1:27 am

  #116405

  I have One Doubt on Update Statement.

  I have field value like

  ' xxx123456',

  'xxx789654',

  'xxx456987'.

  now I want to update taht value as last digit four ones like

  'xxx121111',

  'xxx781111',

  'xxx451111'

  Please Help me out this Problem..

• Anurag Goel

  SSC Enthusiast

  Points: 104

  More actions

  March 13, 2007 at 2:39 am

  #694600

  hi,

   select replace(columnname,right(columnname,4),'1111') from tablename

   

  regards

  Anurag

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  March 14, 2007 at 9:16 am

  #694977

  How about

  UPDATE tableName SET colName = ... WHERE colName LIKE '%1111'

  ?

• Marvin D

  SSCarpal Tunnel

  Points: 4058

  More actions

  March 16, 2007 at 10:40 am

  #695511

  Looking at your request, the replace method is definately the best option.

  Marvin Dillard
  Senior Consultant
  Claraview Inc