Search results
15 wrz 2008 · If you need to write just one condition, then iif() is sufficient, however if you want to write multiple iif() conditions within one statement then you will have to use `case' statement as demonstrated in above responses. Here is an example for your reference.
12 wrz 2019 · SELECT CASE WHEN TRY_CONVERT(int,[Text]) < YEAR(GETDATE()) THEN 'In the Past' WHEN TRY_CONVERT(int,[Text]) = YEAR(GETDATE()) THEN 'Current Year' WHEN TRY_CONVERT(int,[Text]) > YEAR(GETDATE()) THEN 'In The Future', ELSE 'Error' END FROM YourTable;
28 maj 2024 · We can use either a CASE statement or an IIF() function to implement IF-THEN logic in SQL. In this tutorial, we’ll explore how to implement IF-THEN logic in SQL across various dialects such as SQL Server, MySQL, and PostgreSQL.
2 maj 2014 · I want to loop through values and strip 1 character at a time from the values and display the result. So if I have a table with values: ID ___ 34679 13390 89906 I want the result to look like th...
9 maj 2024 · A review of all core SQL string functions, including their definitions and examples. SQL string functions manipulate string (including text and alphanumeric) values. Also known as text functions in SQL, string functions take one or more string values as an argument and return a modified string value. Check out this interactive course on ...
Converts the string argument to base-64 encoded form and returns the result as a character string with the connection character set and collation. If the argument is not a string, it is converted to a string before conversion takes place. The result is NULL if the argument is NULL.
28 sty 2021 · The SQL LIKE operator can be used to search for static and wildcard string patterns within any character-based column. In this tutorial we will go through examples showing the many different ways the LIKE operator can be used.
