Small SQL Query to Append Value to Column

$10-30 USD

Completed

Posted

almost 11 years ago

$10-30 USD

Paid on delivery

I'm looking for some quick help with a simple SQL query to append a string to all the values of a column in a table. The columns is called "productType". I want to append the string "778a" to all the current values of that column using a query in SQL management studio. Current table: ------------- productType ------------- apple ------------- orange ------------- pear ------------- Table after query: ------------- loginName ------------- apple778a ------------- orange778a ------------- pear778a ------------- Thanks,

SQL

Project ID: 5558158

About the project

5 proposals

Remote project

Active 11 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@iCharma

Hi, this is your sollution: UPDATE table SET productType=Convert(VarChar(80),productType) + Convert(VarChar(80),'"&778a&"') Looking further for any questions you might have. All best, Flavia

$10 USD in 0 day

5.0

(3 reviews)

1.1

5 freelancers are bidding on average $14 USD for this job

@shuiwatermizu

I can help .

$15 USD in 1 day

5.0

(3 reviews)

3.2

@calmeyda

Hello my friend, I have worked for you before, I would like help you one more time. Please check my profile to get references about me.

$15 USD in 1 day

5.0

(1 review)

2.7

@webNeat

Hello, You may use this to fix you issue: UPDATE table_name SET productType = CONCAT(productType,'778a'); if this works for you please award the project to me. Thanks :)

$15 USD in 0 day