during my testing or learning on Full text search , i found below queries are returning different results .can you please guide me why
select [BusinessEntityID] , [Name] from [Person].[Person_BK]
where contains([Name], ‘*ASDGDE*’) or contains([Name], ‘*AFASFA*’)
select [BusinessEntityID] , [Name] from [Person].[Person_BK]
where [Name] like ‘%ASDGDE%’ or [Name] like ‘%AFASFA%’
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)