About the Data Vault SQL Reference
Introduction to SQL Reference for Informatica Data Vault
Date and Time Arithmetic
WHERE Clauses
UNION Operator
Parameterized Query
Functions
- Functions Overview
- ABS
- AVG
- CEILING
- CHAR
- COALESCE
- CONCAT
- COUNT
- DATE
- DATE (Date and Time)
- DAY
- DEC
- DIGITS
- EXP
- EXTRACT
- FLOOR
- HOUR
- IFNULL
- INT
- LASTDAY
- LEFT
- LEN
- LN
- LOG10
- LOWER
- LTRIM
- MAX
- MICROSECOND
- MIN
- MINUTE
- MOD
- MONTH
- NANOSECOND
- NULLIF
- PI
- POSITION
- POSSTR
- POWER
- REPLACE
- RIGHT
- ROUND
- RTRIM
- SECOND
- SIGN
- SQRT
- SUBSTRING
- SUM
- TIME
- TODAY
- TRIM
- UPPER
- YEAR

Data Vault SQL Reference

6.4.3 HotFix 1
- 6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3

Back Next

Example of a Simple CASE

SELECT lastname, 
       CASE dept
          WHEN 'A' THEN 'Administration'
          WHEN 'D' THEN 'Development'
          WHEN 'Q' THEN 'Quality Assurance'
          WHEN 'T' THEN 'Technical Writing'
          ELSE '(unknown department)'
       END
FROM employees;

In this example, the employees
table is searched for employee last name and department. But instead of returning the single character that represents a department, a CASE statement is set up to return the full (or default) department name. If the dept
value is ‘A’, the string ‘Administration’ is returned; if the dept
value is ‘D’, ‘Development’ is returned; and so on. If the dept
value matches none of the single characters tested in the CASE statement, the default string ‘(unknown department)’ is returned instead.

Rename Saved Search

Table of Contents

Data Vault SQL Reference

Data Vault SQL Reference

Example of a Simple CASE

Example of a Simple CASE