How To Code This VFP IIF Statement In SQL

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How To Code This VFP IIF Statement In SQL

Message

23/06/2008 12:20:26

23/06/2008 12:18:36

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Divers

Thread ID:

01326128

Message ID:

01326129

Vues:

>How do I put this in SQL syntax:
>
>

>IIF(((TRANCODE="PR") .OR. (TRANCODE = "PT" .AND. TRANQUANT > 0)),TRANQUANT,0) AS Recepit
>

CASE WHEN (TRANCODE = 'PR') OR (TRANCODE = 'PT' AND TRANQUANT > 0) THEN TRANQUANT 
     ELSE 0 END AS Recepit

--sb--