Top "Case-statement" questions

A case statement allows sequences of SQL statements to be selected for execution based on search or comparison criteria, and is typically used in stored procedures.

SQL compare string

CASE WHEN ' 1a' = ' 1a ' THEN 'EQUAL - but it isn´t- HELP!!!!' ELSE 'UNEQUAL' END from …

string oracle oracle11g compare case-statement
MySQL Joins With Case Statements

I am having a bit of trouble with a query. I want to join tables if a case is met. …

php mysql sql case-statement
Case in nested select

I'm having trouble getting a CASE statement to work in a nested select. I think I'm close but I can't …

sql sql-server sql-server-2008 case-statement
C - Tricky Switch Case working .. !

Folks, Recently started learning C. Stuck at a point. Its about working of switch-case statement. Here's the code : #include<…

c switch-statement case-statement
Pattern matching variables in a case statement in Haskell

If I compare a string literal to a string literal using the case statement, I get the expected behavior: if …

string haskell comparison case-statement
Ruby/Rails passing array to case

Here is the scenario: case code when 'www', '', nil false when 'code1', 'code2'... 'code_n' # The array …

ruby case-statement
Can the SQL Case Statement fall through?

Is there a way to make a CASE statement in SQL fall through like the case statement in C#? What …

sql-server case-statement