SQLServer中判断变量中字符串是否存在

declare  @customer_type_id int,
		@v_department varchar(200)
set @v_department='测试v'
if @v_department like '%v%'
	begin
		set @customer_type_id=6
	end
else
	begin
		set @customer_type_id=1
	end
select @customer_type_id       --6