Re: If, then, else SQL select query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



=?Utf-8?B?bHlyaWMyMDAy?= <lyric2002@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:E70E2CF2-E81C-4C8F-BF5F-059E7D2C6629@xxxxxxxxxxxxx:

> For each row:
> when table1.column1 = 'data' or table2.column1 = 'data' or
> table2.column2 ='data' or table2.column3 = 'data' then 'constant'
>
>

Look up help for the IIF() function. But I strongly suspect a design
problem here...


B Wishes


Tim F

.



Relevant Pages