Thanks in advance for reading this. For SQL 2K.
There are two fields: description is char(60) and longdescription as text.
What I want to do is select description only if longdescription is empty or no test in it.
description = CASE WHEN (longdescription IS NULL) THEN description
But it just select blank.
description = CASE WHEN (longdescription = '') THEN description
where codeid = '00007'
But got this error msg:
Server: Msg 306, Level 16, State 1, Line 1
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
Can you please help?
T I A !