Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IIF in SqlServer and Overview for SQL server Functions
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00803735
Message ID:
00803791
Views:
6
Hello,

If you unzip the xsource ( in VFPDir\Tools\xsource) you
found in VFPSOURCE\WIZARDS\WZUPSIZE\EXPRMAP.DBF a table with FOX/SQL/ORACLE function mapping.

Marcel

>Hi everybody!
>
>1 - I am searching for something in SqlServer that is similar to IIF in the Fox syntax. I need to retrieve a string via SqlExec from Sql-Server where one field should be composed by RTRIM(firstname)+RTRIM(Lastname) and in between a space "IIF" firstname is empty.
>
>2 - By the way: is there anybody who know can tell me where to find an overview of fox-Functions and how to realize them within SQL server?
Previous
Reply
Map
View

Click here to load this message in the networking platform