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