Colum concantenation

[L_B_F]

I have need to issue a query similar to the following:

SELECT (colx + coly) as Stuff
FROM whatever

in an application built using the compact framework. It should be a
piece of cake... However the application issues an exception and
complains thusly:

"the data type is not valid for the arithmetic operation"

Is there a workaround?

Greg

 

[Ilya Tumanov [MS]]

Assuming that's SQL CE, it should work except for "the image and ntext data
types".

Please see this for more details:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_
lce__string_concatenation_.asp

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

 

[L_B_F]

You are correct; I discovered the ntext restriction minutes after
posting - and of course that was the data type being used.

Thanks for the reply though. I could still be looking for the answer.

Greg