Loading

How to put condition in case statement

Pinku

Select Case searchText
Case searchText.IndexOf("/") <> -1

here case statrement is not checking the condition.
how to use this

2 Replies

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

Rijwan Ansari4y ago
You case
SELCT
         CASE
                WHEN ColumnName.IndexOf("/") <> -1 THEN ColumnName
                ELSE "Your Value"
         END As searchText
FROM TableName
General Structure sample.
SELECT
CASE
    WHEN Quantity > 30 THEN 'The quantity is greater than 30'
    WHEN Quantity = 30 THEN 'The quantity is 30'
    ELSE 'The quantity is under 30'
END AS QuantityText
FROM OrderDetails;
Muhammad Imran Ansari4y ago
If you are using SQL then use the CHARINDEX(substring, MainString) function.
Select searchText,
CASE WHEN CHARINDEX('/', searchText) <> -1 THEN 'YourMessage' END