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

11/05/2008 20:24:13

Naomi Nosonovsky
Wisconsin, États-Unis

À

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:

01316337

Vues:

10

This message has been marked as the solution to the initial question of the thread.

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

ISNULL() function. Look also at COALESCE().

See also

http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping

If it's not broken, fix it until it is.

My Blog

Click here to load this message in the networking platform