Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you do this in SQL Server 2000?
Message
From
12/01/2003 09:43:37
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: How do you do this in SQL Server 2000?
Miscellaneous
Thread ID:
00740729
Message ID:
00740775
Views:
11
>SELECT iif(isempty(field1),0,1) as myfield FROM mytable
>
>I want to use IIF and isempty in SQL 2000

Hi Mike,

Sergey has given you the right answer. You can find answers to all your syntax needs < g > in the Microsoft SQL Server Books Online downloadable from the SQL Server web pages.
Previous
Reply
Map
View

Click here to load this message in the networking platform