database in SQL2K need help in upading/adding 2 memo columns

  • Thread starter Thread starter Mac
  • Start date Start date
M

Mac

I have database in SQL2K. I have a memo column called memo1. I want to
update memo with "dicount % "+memo1.

I want to insert "discount %" in front of memo1.

This is going to be just one time shot. There are more 20,000 records need
to be updated.

I would appreciate if someone can help me.

I can run VB program and script so if anyone can help me to create something
in VB, if it is not possible in SQL2K,
I would really appreciate.

Thanks
 
Hi,

IN SQL 2000 you could write a simple Update statement

Update Tablename
set memo1 = 'discount % ' + memo1

This will update all the 20K records in a single shot.

Did I answered your question?

Thanks
Hari
SQL Server MVP
 
Hari:

Thanks for your quick response.

I already tried this and I am getting data type error.

Thx
 
Back
Top