Loading

can we use condition in case statement

can we use condition in case statement

Pinku

4y810Learn iOS Programming

Select Case Text1
Case Text1.Length = 10 Or Text1.Length = 13

this above condition is not working..

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Muhammad Imran Ansari4y ago
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
+1
Rajeesh Menoth4y ago
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
+1
Abhishek Singh4y ago
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.
+1
Jignesh Kumar4y ago
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
+1