SQL Case Expression Syntax? - Stack Overflow
Jun 13, 2021 · case expression is the correct term as they evaluate to a scalar value (also. in SQL a statement is terminated by the "statement terminator" which is the semi-colon).
sql - Case in Select Statement - Stack Overflow
Jan 7, 2013 · I have an SQL statement that has a CASE from SELECT and I just can't get it right. Can you guys show me an example of CASE where the cases are the conditions and the …
Best way to do nested case statement logic in SQL Server
I'm writing an SQL Query, where a few of the columns returned need to be calculated depending on quite a lot of conditions. I'm currently using nested case statements, but its getting messy. …
How do I do multiple CASE WHEN conditions using SQL Server …
What I'm trying to do is use more than one CASE WHEN condition for the same column. Here is my code for the query: SELECT Url='', p.ArtNo, p.[Description], ...
CASE (Contains) rather than equal statement - Stack Overflow
Jun 5, 2012 · Is there a method to use contain rather than equal in case statement? For example, I am checking a database table has an entry lactulose, Lasix (furosemide), oxazepam, …
T-SQL: Using a CASE in an UPDATE statement to update certain …
Jun 3, 2022 · You can't use a condition to change the structure of your query, just the data involved. You could do this: update table set columnx = (case when condition then 25 else …
sql - WHERE CASE WHEN statement with Exists - Stack Overflow
Aug 7, 2013 · I am creating a SQL query having WHERE CASE WHEN statement. I am doing something wrong and getting error. My SQL statement is like DECLARE @AreaId INT = 2 …
SQL Server: use CASE with LIKE - Stack Overflow
I am pretty new to SQL and hope someone here can help me with this. I have a stored procedure where I would like to pass a different value depending on whether a column contains a certain …
SQL Server CASE .. WHEN .. IN statement - Stack Overflow
May 18, 2011 · On SQL server 2005 I am trying to query this select statement SELECT AlarmEventTransactionTableTable.TxnID, CASE AlarmEventTransactions.DeviceID WHEN …
SQL: How use case and cast in a query? - Stack Overflow
May 7, 2025 · I want to cast VARCHAR to INT, but in my table i have some value like '???' then SQL Server launch this expcetion : Conversion failed when converting the varchar value '????' …