replacement of InStr function in SQL - SQL Server Central. Microsoft SQL Server tutorials, training
I don't remember IIF strings too well but I think it would be something like the following; select case when col1 like '%abc%' then col1 ... Another way to do it is using a function like InStr called CHARINDEX in SQL Server as follows: SELECT CASE WHEN .....