SQL server regular expression. Fetching keyword from a sentence using regular express

[santoshpras1]

I am using the below query to search some text in a sentence

declare @a nvarchar(100)
set @a=N'%[ /\\@\&\*()\-\+\|\>?,\":;／、・￥—＆＊（－》＞？，；“”〉\- ][public]'

declare @b nvarchar(50)

set @b='public property'

select @b where @b like '%' +@a+'%'

the problem is that I just want to fetch special character or the exact keyword.
example: I want public or &public not republic

could u please help

[Rabbit]

SQL Server doesn't have support regular expressions with the LIKE operator. For more info on SQL Server's version of pattern matching using the LIKE operator, here is a link to their documentation: http://technet.microsoft.com/en-us/l.../ms179859.aspx.

[prigupta2]

Sir please explain in detail so we try to give answer