On Wed, 26 May 1999, Emils Klotins wrote:
>
> I have a SELECT that needs to return a value, if another value is not null, otherwise it should
> return a string 'N/A':
> A simpliefied version of SELECT is this:
>
> SELECT category, CASE (WHEN category IS NULL THEN 'N/A' ELSE name) AS name FROM
> mytable;
>
> I get 'parse error near category'.
>
Try this:
SELECT category, name FROM mytable WHERE category IS NOT NULL
UNION ALL
SELECT category, 'N/A' FROM mytable WHERE category IS NULL;
field `name' must have char type.