Insert Into, Append, Temp Table ?

• finance_teacher

  SSC Eights!

  Points: 855

  More actions

  February 10, 2004 at 5:13 pm

  #65784

  I have two columns, name & keywords

  How can I change the following SQL statement so that it will append data onto the end of the keywords column so that it reads "current info+the new set info below" instead of overwriting the current data ?

  SET KEYWORDS = 'soap, ice, snow'

  WHERE (NAME LIKE '%drink%')

• skrilla99

  SSCertifiable

  Points: 5795

  More actions

  February 10, 2004 at 5:38 pm

  #493537

  Hi ft,

  Try it like this:

  SET KEYWORDS = Keywords + 'soap, ice, snow'

  -Dan B

• finance_teacher

  SSC Eights!

  Points: 855

  More actions

  February 10, 2004 at 9:54 pm

  #493549

  That worked good.

  Thanks for the info.