On Tue, 25 Mar 2003, Chad Thompson wrote:
> The assumtion that char and varchar can be compared is gone. Any comparison
> or in this case concatination between the two types needs to be explicitly
> cast.
>
> try
> SELECT code::varchar || ' ' || diag::varchar, code
> FROM dsm4
> WHERE axis = 1
>
The assumtion that char and varchar can be compared is gone. Any comparison
or in this case concatination between the two types needs to be explicitly
cast.
try
SELECT code::varchar || ' ' || diag::varchar, code
FROM dsm4
WHERE axis = 1
ORDER BY code;
Thanks
Chad
- Original Message -
Fro
