Loading

How to append data to datatable column directly

sarin s

14y2.1kSQL

My MS SQL database Info table contains 2 columns

Id       Info
1        Raj,30
2        Mac,28
3        John,32

Now i want to update my Info table as

Id       Info
1        Raj,30,Black
2        Mac,28,Yellow
3        John,32,Green

So the question is,
Is there any direct method (sql queries / statements) by which i can append black , yellow etc to Info column?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

sarin s14y ago
UPDATE tbl
SET tbl.[Info] = tbl.[Info] + ',' + 'Balck'
WHERE [Id] = 1