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 SkipVought 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
0
0
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
Neither. I shouldn't bother trying to optimize things at that level.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Case sensitive request 1
Replies
3
Views
68
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Converting or getting rid of decimal places 1
Replies
5
Views
93
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
68
Andrzejek
Andrzejek
Bomac8
  • Locked
  • Question
Convert IIF with switch statement to Case
Replies
3
Views
70
dhookom
dhookom
Cpreston
  • Locked
  • Question
ISNULL in CASE and SUM 1
Replies
5
Views
103
Cpreston
Cpreston

Part and Inventory Search

Sponsor

Back
Top