--declare @AssemblyOrderNo varchar(12) --set @AssemblyOrderNo = 'A0000045023' select rtrim(ltrim([No_])) [Item ID], rtrim(ltrim([Description])) [Description] from [Green Circle Growers$Assembly Line] where [Document No_] = @AssemblyOrderNo