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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Case Statement
- Thread starter beth4530
- Start date
- Thread starter
- #3
DaveInIowa
Programmer
If this example is being used in a SELECT, you could try...
Code:
SELECT Field_1, CASE WHEN Field_1 = x THEN n ELSE Field_2 END Field_2
FROM YourTableIt depends on what you are trying to do:
If you are just trying to retrieve data a certain way, use DaveInIowa's suggestion.
If you are trying to update data in a table, use gmmastros' suggestion as part of an update statement.
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
If you are just trying to retrieve data a certain way, use DaveInIowa's suggestion.
If you are trying to update data in a table, use gmmastros' suggestion as part of an update statement.
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
- Status
Similar threads
