Exist IIF function in SQL

Results 1 to 2 of 2

Thread: Exist IIF function in SQL

  1. #1
    Join Date
    Dec 1969

    Default Exist IIF function in SQL

    Exist any similar function in SQL to IIF function of MSAccess<BR><BR>TIA<BR>Peter

  2. #2
    peterjl@austec.net.au Guest

    Default RE: Exist IIF function in SQL

    Just make your own:<BR><BR>&#060;script runat=server language=vbscript&#062;<BR>Function IIf(Cond,V1,V2)<BR>if Cond then <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IIF = V1<BR>else<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IIF = V2<BR>End If<BR>End Function<BR><BR>If you use JavaScript I think it already contains the same conditional operator as in C.<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cond ? V1 : V2;<BR><BR>&#060;/Script&#062;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts