Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-16 : 00:31:41
|
Shayna writes "I have to write a report where a user can pick a single transaction category or 'ALL' categories. I was told to try a decode statement. The decode statement that I have so far looks like this:
ctc.tran_cat_description = decode(:tran_cat_descr, 'ALL', ctc.tran_cat_description)
It will pick up ALL transaction categories, but will not return values if I put a single type in such as MANUAL BATCH.
Can you help me?
:tran_cat_descr is the user variable for the report
Thanks,
Shayna
We are using Windows NT and SQL version 8.0" |
|
|
|
|
|
Decode Statement