Search results
8 gru 2016 · If I understand the question correctly, you want the equivalent of decode but in T-SQL. Select YourFieldAliasName = CASE PC_SL_LDGR_CODE WHEN '02' THEN 'DR' ELSE 'CR' END
23 kwi 2011 · In SQL Server the equivalent code is CASE statement. Here are the examples regarding how DECODE can be written in SQL Server. SELECT CASE WHEN Letters = 'First' THEN 1 WHEN Letters = 'Second' THEN 2 WHEN Letters = 'Third' THEN 3 ELSE 0 END AS LN FROM LettersTable
1 paź 2013 · 1 Answer. Sorted by: 3. You can use CASE function. Select ..... CASE SUBCOM_TYPE. WHEN 'S' THEN 'SPECIAL COMMISION' WHEN 'D' THEN 'DEFAULT COMMISION' END.
SELECT DECODE (3, 1, 'Equal 1,', 2, 'Equal 2', 'Not Equal 1 or 2'); Code language: SQL (Structured Query Language) (sql) This example works like the following IF-THEN-ELSEIF-ELSE statement: IF 3 = 1 THEN RETURN 'Equal 1'; ELSE IF 3 =2 THEN RETURN 'Equal 2'; ELSE RETURN 'Not Equal 1 or 2'; END IF ; Code language: SQL (Structured Query Language ...
20 lis 2017 · I have a varchar column in a table in SQL Server that holds a Base64-encoded text string, which I would like to decode into its plain text equivalent. Does SQL Server have any native functionality to handle this type of thing?
In Oracle, you can use DECODE function to evaluate a list of expressions, and if a value is matched return the corresponding result. In SQL Server, you can use CASE expression that is also supported by Oracle. Note that NULL values in DECODE function and CASE expression are handled differently .
23 paź 2012 · It has been asked on multiple forums, what the EQUIVALENT of DECODE IN SQL SERVER is? Basically, we can achieve the same in SQL Server using Case and IIF statements. Lets view the decode in Oracle. Select DECODE(PoleDirection, 'North','N', 'South','S', 'East','E','WEST','W', 'Not Applicable') AS [Poles] FROM TablePoles
