Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IIF in SqlServer and Overview for SQL server Functions
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00803735
Message ID:
00803791
Vues:
7
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?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform