[Solved] Search box to work like google search [closed]

by


You don’t need the % character, since the function Contains already implied that.
So :

select Subject from [dbo].[Email] where Contains(Subject,'t')

The % are for LIKE function

select Subject from [dbo].[Email] where Subject LIKE '%t%'

1

solved Search box to work like google search [closed]