Modifying all data in a given column (SQL)

[aftershxck]

Hey,

I've tried googling for a solution to this but I'm not completely sure of what approach I should be taking.

If I had a table with say 100 records, and for a given column, I wanted to modify the data for every row (i.e. append some chars), how would I go about doing this? What is the most efficient way?

Thanks for any advice!

 

[aftershxck]

Hi,

I'll give it a try


Thanks