SQL Case

Select
CASE [World Wide Service]
WHEN 1 then [Shipping Agent Code] + '-W'
ELSE [Shipping Agent Code]
end,
Description, [World Wide Service] from [COMPANYNAME$E-Ship Agent Service]