Posted by Dima Gofman on 09/21/05 16:01

I want to execute something like

select iif(type='credit',amount*-1,amount) from table

how can i do that? help file says iif is used in Multidimensional
Expressions but that seems overly complicated for this task.

any ideas?

• Next in forum: Re: inline if
• Prev in forum: search on concatenated fields in sql server
• Thread view: inline if

[Reply to this message]