Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does iif() exist in sqlserver ?
Message
From
10/08/2007 08:04:08
 
 
To
10/08/2007 05:57:25
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01247302
Message ID:
01247313
Views:
21
SQL Server's IIF:
CASE WHEN condition THEN value1 ELSE value2 END
SQL Server's ISNULL():
value1 IS NULL
ISNULL(x,y) can be done this way:
CASE WHEN x IS NULL THEN y ELSE x END
>i have tried to creat a remote view using iif() function but sqlserver doen't recognize this. how can i do it ? (i also tried it in sqlserver view designer but it was the same thing)
>
>another function have the same problem : isnull(x,y) sqlsqerver function. works well in sqlserver but doen't work with the remote view designer in vfp.
>
>i need informations to continue my work...
robert.oh.
Previous
Reply
Map
View

Click here to load this message in the networking platform