Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 108
  • Last Modified:

Updating a vary jar field

Hi, I have a vary jar field thar I would like to be able to updatell,  but leave the original data in the field.  Is this possible?
Any help would be appreciated.
Thanks
0
Morpheus7
Asked:
Morpheus7
  • 2
  • 2
1 Solution
 
ste5anSenior DeveloperCommented:
A WAT? Please rephrase your question.
0
 
Morpheus7Author Commented:
Hi,
Apologies, spell check took over. It should say  
Varchar.
0
 
Morpheus7Author Commented:
I have a Varchar column in a table and I  would like to be able to update the column without removing the original data, to be able to the  data already there.
Would it be possible to do this?
Many thanks
0
 
ste5anSenior DeveloperCommented:
UPDATE yourTable
SET column = column + 'new data'
WHERE condition;

Open in new window

0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now