Thread: Case

Hello,

what's wrong when you receive this message from an select statement
: CASE types "date" and "text" not matched 

thank you for any help  

-- 
Best regards,Cwhisperer                          mailto:Cwhisperer@vo.lu

Cwhisperer writes:

> what's wrong when you receive this message from an select statement
> : CASE types "date" and "text" not matched

You probably did something like

CASE WHEN something THEN date_value ELSE text_value

The data types in the result branches of a case expression need to match.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter