Top "Case" questions

Missing Keyword (ORA-00905) - Oracle SQL Case Statement

Good morning, I was wondering if one of you could help me - should be fairly quick I'd imagine; I'm …

sql oracle case ora-00905

MySQL CASE to update multiple columns

I would like to update multiple columns in my table using a case statement, but I cannot find how to …

mysql sql case

Execution order of WHEN clauses in a CASE statement

Given the following body of a case statement: 1 WHEN r.code= '00' then 'A1' 2 WHEN r.code ='01…

sql case sybase case-when

VHDL Case/When: multiple cases, single clause

Inside a process I have something like this: CASE res IS WHEN "00" => Y <= A; WHEN "01" => Y <= …

case vhdl

ERROR: CASE types character varying and numeric cannot be matched

I am writing a select statement in Postgres which contains case statement as follows: ,(case when all_loc.country = 'DE' …

sql postgresql select case

Convert string to Pascal Case (aka UpperCamelCase) in Javascript

Id like to know how I can covert a string into a pascal case string in javascript (& most probally …

javascript regex case

SQL Server Convert in Case Statement

I have a column called compositeRate, it is a decimal(10,2) datatype. I am writing a Select statement that should return …

sql-server case case-statement

Extract numbers from a field in PostgreSQL

I have a table with a column po_number of type varchar in Postgres 8.4. It stores alphanumeric values with some …

regex postgresql conditional case regexp-replace

What are the different kinds of cases?

I'm interested in the different kinds of identifier cases, and what people call them. Do you know of any additions …

case naming camelcasing

tsql : is it possible to do nested case statements in a select?

how do i incorporate a nested if statement in a select clause of a sql query? I know to use …

tsql case