Updating part of field value

• msregalla

  Say Hey Kid

  Points: 712

  More actions

  January 30, 2002 at 4:35 am

  #101071

  Hi friends,

  I am performing a search and replace on columns having different data types (note not only "Text" or "Image" data) through my VB application using ADO in SQL SERVER 6.5.

  Oracle provides a "Replace" function for that which can be used in a an update statement for searching for a perticular work within the field value and update with the replace string.

  Does SQL Server 6.5 provides any functions for that purpose?????

  Any kind of procedure also works fine for me. If u can suggest a direct function it will be very helpful.

  Thanks in advance

• Steve Jones - SSC Editor

  SSC Guru

  Points: 735657

  More actions

  January 30, 2002 at 10:05 am

  #422877

  Not sure about v6.5. There is a replace in v7/2000. check the BOL on v6.5

  Steve Jones

  steve@dkranch.net

• rams_krish

  SSC Rookie

  Points: 41

  More actions

  January 30, 2002 at 9:20 pm

  #422893

  Hi,

  SQL Server has got a REPLACE function as well.