Inserting a common string to a whole column in a table (1 Viewer)

hello evrbdy.

Im in a critical situation. as i had less experience with sql srvr quires, i came here to find some help. my situation a simple one which im uanble to tackle without using query in sql (which Im not good at).

this is my problem..

I have a coloumn which is VARchar with a limit of 15. this column is having over 10000 records. now, I need to insert a string like "A" in each record of the whole column. I cant use the find and replace with Wild caracters. (replacing with wild characters makes the whole data records with the wild chars!!!) so, please help me out with a solution. Im in desperat need of the solution.

Unless you wish to use Query Analyzer and do it for each record your gonna have to do it using a query.

Here is an example you could use:

UPDATE table_name SET table_field = 'A'

I prefer to use nvarchar instead of varchar.

This will update every record in the table and set the field to the value you want.

Thank you.. max will try.