can we use condition in case statement

Question

Select Case Text1 Case Text1.Length = 10 Or Text1.Length = 13 this above condition is not working..

Jignesh Kumar · Answer

Hi Pinku, You can use or condition in Case statement, Please use like this, declare @Text1 varchar(10) set @Text1 = 'Test' Select Case when Len(@Text1) = 4 Or Len(@Text1) = 13 then 'True' Else 'False' End

Muhammad Imran Ansari · Answer

Yes, You can use condition in case statement. CASE can be used in any statement or clause that allows a valid expression. SELECT Text1, CASE WHEN LEN(Text1) = 10 OR LEN(Text1) = 13 THEN 'Text1 Length is Between 10 to 13' ELSE 'Text1 Length is greater than 13' For more detail check the following link: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/case-transact-sql?view=sql-server-ver15

Rajeesh Menoth · Answer

Hi, Yes, You can use case statements in SQL. Try this : SELECT Text1, CASE WHEN Text1.Length = 10 THEN 'The quantity is equal to 10' WHEN Text1.Length = 13 THEN 'The quantity is equal to 10' ELSE 'The quantity is greater than or less than 10 or 13' END AS TableLengthInfo FROM Table_Name; Reference: https://www.w3schools.com/sql/sql_case.asp

Abhishek Singh · Answer

above query can be resolved like this: select case when Len(text1) = 10 or Len(text1) = 13 then "Select your output" if you need nested case then try this(not 100% sure if it'll work ) select case when Len(texty1) =10 then case when Len(text1) = 13 then "select your output" you can also do it with if-else.