Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server select syntax
Message
 
 
To
29/06/2005 11:16:54
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01027150
Message ID:
01027417
Views:
23
>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--
Previous
Reply
Map
View

Click here to load this message in the networking platform