How do you say it in SQL? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How do you say it in SQL?

Message

From

02/09/2008 14:51:56

Paul Mrozowski
Rcs Solutions, Inc.
Macomb, Michigan, United States

To

02/09/2008 14:01:35

Naomi Nosonovsky
Wisconsin, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: How do you say it in SQL?

Environment versions

Visual FoxPro:

VFP 7 SP1

OS:

Windows XP SP2

Network:

Windows 2000 Server

Database:

Visual FoxPro

Miscellaneous

Thread ID:

01344218

Message ID:

01344257

Views:

11

>In VFP you would use NVL() function.
>
>In SQL Server you would use ISNULL() or COALESCE().
>
>I don't know what would you use in Oracle or MySQL.

Yes. Actually, I misread the "Network" field - I saw Windows 2000 Server but the brain decided that was SQL Server 2000 (completely overlooking "Database").

-Paul

RCS Solutions, Inc.
Blog
Twitter

Click here to load this message in the networking platform