Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What to use instead of NVL() when using SQL Server?
Message
From
13/05/2008 04:04:13
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
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:
01316583
Views:
18
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform