Search results
8 gru 2016 · While a CASE based solution works for most cases, it probably doesn't take into account NULL values. Oracle's DECODE is NULL safe, meaning that. DECODE(a, b, c, d, e, f) Translates to this standard SQL expression (which can be used starting with SQL Server 2022):
27 sty 2015 · I have a column in SQL Server with utf8 SQL_Latin1_General_CP1_CI_AS encoding. How can I convert and save the text in ISO 8859-1 encoding? I would like to do thing in a query on SQL Server.
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. Here are few alternative blog posts.
23 maj 2023 · This example displays a date and time as character data, uses CAST to change the character data to the datetime data type, and then uses CONVERT to change the character data to the datetime data type.
22 mar 2016 · I have a column with values saved as hexadecimal. When I run this query: select column from table. where column like '%22639935-KCN%'; This is the output I get: 0x24000000008B010000000089FF32323633393933352D4B434E000000. I would like to turn the output into a varchar.
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 · Just as an alternative, Azure SQL Database supports decoding base64 encoded values into varbinary which can then be converted into a varchar value. convert(varchar(max), BASE64_DECODE([BASE64_ENCODED_COLUMN_NAME]))
