Search in Books online for Case When

Peter
Software Engineer / Trainer
Vervoorn IT
----- Original Message ----- 
From: "Mark Roworth" <mark.roworth@b...>
To: "professional vb" <pro_vb@p...>
Sent: Monday, September 23, 2002 10:45 AM
Subject: [pro_vb] Re: IIF function


> No that's fine, but I'm using SQL Server (and ADO 2.5), and SQL Server
> doesn't seem to support the IIF function. The question I'm asking, is, is
> there an equivalent function on SQL Server?
> 
> Mant thanks,
> 
> Mark Roworth
> Dolphin Computing Ltd
> 01273 262865
> mark.roworth@b...
> 
> -----Original Message-----
> From: Carl Radley [mailto:carl.radley@b...]
> Sent: 23 September 2002 09:12
> To: professional vb
> Subject: [pro_vb] Re: IIF function
> 
> 
> Hi,
> VB has an IIF function but you are talking about SQL statements.
> 
> VB can handle DAO (Access), ADO, to name but a few.
> You need to create a reference to the library of your choice.
> If you are comfortable with Access, then use DAO although most will tell
> you (including me) to use ADO as it is more popular, powerful, etc (and
> can handle Access easily)
> 
> Your SQL statement will work with ADO.
> 
> Hope this helps,
> Carl
> 
> ---
> Visual C# - A Guide for VB6 Developers
> This book will make it easy to transfer your skills
> from Visual Basic 6 to C#, the language of choice
> of the .NET Framework.
> http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059
> 
> 
> 
> 
> ---
> Visual C# - A Guide for VB6 Developers
> This book will make it easy to transfer your skills 
> from Visual Basic 6 to C#, the language of choice 
> of the .NET Framework.
> http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059
> 
>