Update column by adding a suffix

See more:

SQL

SQL-Server-2008R2

updating

I have some data with given below

Product table

ProductID	ProductName	             SupplierID
1	           Chai    	                1
2	           Chang	                1
3	           Aniseed Syrup	        1
9	           Mishi Kobe Niku  	        4
10	           Ikura	                4
11	           Queso Cabrales	        5
12	           Queso Manchego La Pastora	5
74	           Longlife Tofu	        4

I want to update the table on a criteria and append a suffix to the column values on the given 'Where' condition
as shown below
I want to update those record who have 1 and 4 as supplier id by appending v.1 string to the column value

ProductID	ProductName	       SupplierID
1	           Chai .v1    	          1
2	           Chang.v1	          1
3	           Aniseed Syrup.v1	  1
9	           Mishi Kobe Niku.v1  	  4
10	           Ikurav.14	          4

Declare
@Suffix varchar(10)='v.1'
Update Product
set ProductName=(select ProductName from Product where SupplierID in (1,4)+@Suffix)
where
where SupplierID in (1,4)

But it wont work . Please help