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

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

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

Message

From

11/05/2008 20:24:13

Naomi Nosonovsky
Wisconsin, United States

To

11/05/2008 20:18:56

Dmitry Litvak
Massachusetts, United States

General information

Forum:

Microsoft SQL Server

Category:

Other

Title:

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

Environment versions

SQL Server:

SQL Server 2005

Miscellaneous

Thread ID:

01316336

Message ID:

01316337

Views:

9

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