Thanks guys,

I was trying to replace ' with %. your solution is better.

cheers

THANKS.

Its 100% working.

Can I add something that We can do that without #tmp table We can use query

where (filedname COLLATE SQL_Latin1_General_CP1_CI_AI ) like '%Gar%'

[Source]

http://lists.evolt.org/archive/Week-of-Mon-20070430/189725.html