What to use instead of NVL() when using SQL Server? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

What to use instead of NVL() when using SQL Server?

Message

De

13/05/2008 04:04:13

Cetin Basoz
Engineerica Inc.
Izmir, Turquie

À

11/05/2008 20:18:56

Dmitry Litvak
Massachusetts, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Re: What to use instead of NVL() when using SQL Server?

Versions des environnements

SQL Server:

SQL Server 2005

Divers

Thread ID:

01316336

Message ID:

01316583

Vues:

20

>When sending a SQL Select command to SQL Server via SPT what is the SQL Server equivalent of VFP function NVL()?

There is Isnull() and coalasce(). But also there is, maybe better,
case
when ... then ...
when ... then ...
else ...
end

Cetin

Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad

Click here to load this message in the networking platform