how to add a patern to all data in a table

Question

hello,
i want to rename all data in a table from  whatever to whatever_new (add _new to all entries) with one command

how?

---

Dimitris Koutsoukos

Answer 1

Hi Dimitris,

Thanks for your post.

However, this forum is to address questions about the Open Protocols Specifications.

I suggest you post your question at a more suitable forum like:

SQL Server Data Access
Questions and discussion about data access to SQL Server using SQL Native Client, OLEDB, ODBC, ADO, WDAC/MDAC, JDBC, or SOAP/HTTP.

http://forums.microsoft.com/TechNet/ShowForum.aspx?ForumID=87&SiteID=17


Thanks and regards,

---

SEBASTIAN CANEVARI - MSFT SEE Protocol Documentation Team

Answer 2

thank you i did 

---

Dimitris Koutsoukos