declare @path varchar(100)='C:\labs\Images\'

SELECT ThumbNailPhoto,@path+ThumbnailPhotoFileName as Path
from Production.ProductPhoto