declare @SearchString varchar(150) = 'Banana'
set @SearchString = replace(@SearchString,'a','[abc]');
set @SearchString = replace(@SearchString,'b','[abc]');
select @SearchString
结果将是
@SearchString = [abc][a[abc]c]n[a[abc]c]n[a[abc]c]
我想要的是
[abc][[abc]c
我该怎么做?
我找到了另一种方法是比较两侧的替换,如下所示
Declare @Keyword varchar(50)='أحمد'
Select name from names where Replace(name,'أ','ا') = replace(@keyword,'ا','أ')
那会让我得到"أحمد"和"احمد">