Is there StartsWith or Contains in t sql with variables?

Question

I am trying to detect if the server is running Express Edition.

I have the following t sql.

DECLARE @edition varchar(50);  set @edition = cast((select SERVERPROPERTY ('edition')) as varchar)  print @edition 

In my instance, @edition = Express Edition (64-bit)

How can I do the following? (C# inspired).

DECLARE @isExpress bit; set @isExpress = @edition.StartsWith('Express Edition'); 

Answer 1

StartsWith

a) left(@edition, 15) = 'Express Edition' b) charindex('Express Edition', @edition) = 1 

Contains

charindex('Express Edition', @edition) >= 1 

Examples

left function

set @isExpress = case when left(@edition, 15) = 'Express Edition' then 1 else 0 end 

iif function (starting with SQL Server 2012)

set @isExpress = iif(left(@edition, 15) = 'Express Edition', 1, 0); 

charindex function

set @isExpress = iif(charindex('Express Edition', @edition) = 1, 1, 0);