Re: Function in selection?

Thanks, I'll try it right away!

May

> May,
> 	I think this is what you want.
> 
> SELECT CASE WHEN A=0 and B<>0 THEN B*Z.TABLE_Y ELSE A END AS A, CASE WHEN
> A<>0 AND B=0 THEN A/Z.TABLE_Y ELSE B END AS B FROM TABLE_X ORDER BY D, C, E
> 
> Thanks,
> Peter Darley