Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

isnull or case

Status
Not open for further replies.
sneki

sneki

Programmer
Nov 26, 2003
11
SI
SELECT ISNULL(value1, value2) as col,...
or
SELECT col = CASE WHEN value1 is null THEN value2 END, ...

What kind of statment is faster?
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Case sensitive request 1
Replies
3
Views
120
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Converting or getting rid of decimal places 1
Replies
5
Views
160
Andrzejek
Andrzejek
ahmedsa2018
  • Locked
  • Question
How to give same number if it exist on table or new number if it not exist based on part value? 1
Replies
8
Views
154
Andrzejek
Andrzejek
Bomac8
  • Locked
  • Question
Convert IIF with switch statement to Case
Replies
3
Views
106
dhookom
dhookom
Cpreston
  • Locked
  • Question
ISNULL in CASE and SUM 1
Replies
5
Views
278
Cpreston
Cpreston

Part and Inventory Search

Sponsor

Back
Top