Archives of the TeradataForum

Message Posted: Fri, 01 May 2009 @ 14:08:56 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Friday, May 01, 2009 11:32 -->

Hi Glenn,

Thank you for your input.

I actually managed to fix the problem right after posting my message.

It had to do with the simple fact that the single quotes I used in the sql were not recognized due to the fact I copied them (and the whole conditional clause)from a word document and pasted into my program!

Also, you are totally correct about the embedded cases clause... As soon as I fixed the problem with the quotations

I realized I should move the first case statement into a where clause the way you did.

Thanks again!

	<Prev	Next>		<<First	<Prev	Next>	Last>>