Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server select syntax
Message
 
 
À
29/06/2005 11:16:54
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01027150
Message ID:
01027417
Vues:
21
>I was wrong I just checked with someone and it is possible to have a blank judge code.

I asked a question two times and you ignored it both times so I'm going with my understanding of that condition. As Bo suggested, I would use NULL instaed of empty for parameters.
WHERE 
  -- judgecode is not empty 
  LEN(judgecode) > 0 
         AND ( @parameter IS NULL OR judgecode = @parameter)
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform