How to add 2 columns together

Thread View: comp.databases.ms-sqlserver

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Mac Wed, 06 Apr 2005 22:06

#88

Author: Mac
Date: Wed, 06 Apr 2005 22:06

19 lines
1564 bytes

SQL2K
--------


I have 2 columns, one is numeric and 2nd is TEXT or memo column.

I have been trying for the last few days with no success.

Here is the statement that I have been using:


UPDATE MYTABLE
SET MYMEMO = STR(PERCENTAGE,7)+'   '+MYMEMO

When I run it, I get data type error.

I would appreciate if someone please help me here.

Thx

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads