MsSql Select IIF() Function

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

MsSql Select IIF() Function

Message

From

30/01/2007 05:36:37

All

General information

Forum:

Visual FoxPro

Category:

Client/server

Title:

MsSql Select IIF() Function

Environment versions

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP SP2

Network:

SAMBA Server

Database:

MS SQL Server

Miscellaneous

Thread ID:

01190389

Message ID:

01190389

Views:

Does there have a similar IIF() commnad in MsSql?

I try to do this but fail :

select id,IIF(type='A',1,2) AS indicator From tableA

TIA.

Regards,