Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Updating a vary jar field

Posted on 2014-10-14
4
Medium Priority
?
106 Views
Last Modified: 2014-10-29
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
Comment
Question by:Morpheus7
  • 2
  • 2
4 Comments
 
LVL 36

Expert Comment

by:ste5an
ID: 40379579
A WAT? Please rephrase your question.
0
 

Author Comment

by:Morpheus7
ID: 40379834
Hi,
Apologies, spell check took over. It should say  
Varchar.
0
 

Author Comment

by:Morpheus7
ID: 40380889
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
 
LVL 36

Accepted Solution

by:
ste5an earned 2000 total points
ID: 40381629
UPDATE yourTable
SET column = column + 'new data'
WHERE condition;

Open in new window

0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question