Declare @Test varchar(100) = 'aaa@aaa';
IF @Test Like '%@%'
BEGIN
print ' contains @'
END
ELSE
print ' doesn''t contain @'
This article on checking if a varchar contains a specified character is super helpful! It’s just like using Fira Code for clear and efficient coding—making string operations much more intuitive!
This article on checking if a varchar contains a specified character is super helpful! It’s just like using Fira Code for clear and efficient coding—making string operations much more intuitive!
ReplyDelete