SQL Server Developer >> CASE WHEN within the Where clause.
Hi all.
Any syntax examples on using a "CASE WHEN' within the where clause. Is it
legal? Need to use different searchcriteria based on a table value. Something
like...
AND (CASE WHEN OrderHead.FieldX = 1 THEN OrderLine.FieldN = 4 ELSE
OrderLine.FieldN = 2)......
Somehow I have ended in a situation that needs something like this :-)
> Hi all.
> Any syntax examples on using a "CASE WHEN' within the where clause. Is it
> legal? Need to use different searchcriteria based on a table value. Something
> like...
>
>
> AND (CASE WHEN OrderHead.FieldX = 1 THEN OrderLine.FieldN = 4 ELSE
> OrderLine.FieldN = 2)......
>
>
> Somehow I have ended in a situation that needs something like this :-)
>
> --
> Thanks all
> Regards Geir