SyntaxFix

[sql] SQL Server: use CASE with LIKE

Add an END at last before alias name.

CASE WHEN countries LIKE '%'+@selCountry+'%' 
     THEN 'national' ELSE 'regional' 
END AS validity

For example:

SELECT CASE WHEN countries LIKE '%'+@selCountry+'%' 
       THEN 'national' ELSE 'regional' 
       END AS validity
FROM TableName

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to stored-procedures

• How to create temp table using Create statement in SQL Server? • How do I pass a list as a parameter in a stored procedure? • SQL Server IF EXISTS THEN 1 ELSE 2 • Stored procedure with default parameters • Could not find server 'server name' in sys.servers. SQL Server 2014 • How to kill all active and inactive oracle sessions for user • EXEC sp_executesql with multiple parameters • MySQL stored procedure return value • SQL Server: use CASE with LIKE • SQL server stored procedure return a table

Examples related to case

• PostgreSQL CASE ... END with multiple conditions • SQL Server: use CASE with LIKE • SQL Server IIF vs CASE • SELECT using 'CASE' in SQL • SELECT query with CASE condition and SUM() • GROUP BY + CASE statement • SQL use CASE statement in WHERE IN clause • SQL Server - Case Statement • where to place CASE WHEN column IS NULL in this query • Regarding Java switch statements - using return and omitting breaks in each case

Examples related to sql-like

• SQL Server: use CASE with LIKE • Create hive table using "as select" or "like" and also specify delimiter • How do I find ' % ' with the LIKE operator in SQL Server? • Using LIKE operator with stored procedure parameters • SQL- Ignore case while searching for a string • Is the LIKE operator case-sensitive with MSSQL Server? • Using Eloquent ORM in Laravel to perform search of database using LIKE • SQL 'LIKE' query using '%' where the search criteria contains '%' • How to use "like" and "not like" in SQL MSAccess for the same field? • MySQL SELECT LIKE or REGEXP to match multiple words in one record