General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>OK, OK --- Ya got me ... and Zahid had a good idea about placement of the options.
>>>
>>>Actually, you don't even need your third option (at least with that query).
>>>
>>>With only the two cases, you could write it as an IF.
>>>
>>>:)
>>
>>Not so, l'il Bart ... you still need the CASE even if you get rid of the third option, since there is an implicit option (OTHERWISE) not listed. You'd need two IFs, preferably nested, to get rid of the CASE ...
>>
>>... or were you pulling our collective leg?
>>zahid
>
>No, you're indeed correct, there is the third implied condition, so you would need two IF's. So does this make you Lisa? < g >
I'll cop to Marge, but that's as far as I'll go.
zahid
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only