got it to work..

anyway I used this..

DECLARE @VALUE NVARCHAR(5)

SET @VALUE='384'

SELECT [Supplier],[Name] FROM scheme.plsuppm Where [Name] like '%' + @VALUE + '%'

Thanks..

hehe..

i guess that solves my problem..

thanks to you guys..