Re: SQL syntax hel!

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Tue, 09 Jan 2001 20:36:45 GMT
Message-ID: <3a5b761b.10761360@news.alt.net>

On Tue, 09 Jan 2001 17:11:55 GMT, "Mike" <mike_at_nospam.com> wrote:

>Thank you so much. Just a few moments ago I started to implement my
>application to accept 2 queries
>(break up this one in 2 :-) ).
>I am curious, is there any way to make column info appear completely empty
>after JOIN
>for cases where status='0', so it would not display cancatanation
>strings -->::::<--- in my case?
>I' ve got no problems to clean it up in my Java applet, but still....
>
>Thnak you.
>Mikhail
>

You may want to check out the DECODE function in the Oracle docs. It's like an inline Case statement.

Brian Received on Tue Jan 09 2001 - 14:36:45 CST