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!

Case in views

Status
Not open for further replies.
IanStrange

IanStrange

Programmer
Sep 16, 2002
36
0
0
GB
Hi
Is there is version or similar thing to the case statment that can be used in a view.
We want to show the value from one table if there is one and if there isn't then we want a different value from a different figure to be show. Thanks for any help
Ian

No man is an island but 6 tied together make quite a good raft.
 
Sort by date Sort by votes
Dont worry P.E.B.C.A.C.
Problem
Excists
Between
Chair
And
Computer

No man is an island but 6 tied together make quite a good raft.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Case sensitive request 1
Replies
3
Views
66
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
155
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
116
SaltyTheFrog
SaltyTheFrog
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
84
Auguy
Auguy
Auguy
  • Locked
  • Question
Connection String in .NET program Config File 2
Replies
10
Views
138
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top