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

[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

 

[Hari Prasad]

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

 

[Mac]

Hari:

Thanks for your quick response.

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

Thx

 

[Hari Prasad]

Mac,

Looks like your datatype is TEXT. Inthat case you need to use UPDATETEXT
command to update.

See the below archive posts:-

http://groups-beta.google.com/group/comp.databases.ms-sqlserver/msg/11549ff4637eff45

Thanks
Hari
SQL Server MVP