Okay I enjoyed the case statement so much I tried an IF statement.

can this work?



SELECT
dbo.Made2ManageReport_v.fsono AS 'Sales Order Number',
dbo.Made2ManageReport_v.carriagetype as 'Carraige Type',
dbo.Made2ManageReport_v.angle as Angle,
dbo.Made2ManageReport_v.channel As Channel,
dbo.Made2ManageReport_v.vendor as Vendor,
dbo.Made2ManageReport_v.sections as 'Number of Sections',
====> IF dbo.Made2ManageReport_v.passthrough = "P"
BEGIN
"PASS THROUGH"
END
ELSE
BEGIN
"BACK TO BACK"
END
AS 'PASS THROUGH',
dbo.Made2ManageReport_v.starter,
dbo.Made2ManageReport_v.adder,
dbo.Made2ManageReport_v.standard_pallet,
dbo.Made2ManageReport_v.xright,
CASE dbo.Made2ManageReport_v.antitip
WHEN 'R' THEN 'RIGHT'
WHEN 'L' THEN 'LEFT'
WHEN 'B' THEN 'BOTH'
ELSE 'NONE' END AS AntiTip,
dbo.Made2ManageReport_v.fcustpono,
dbo.Made2ManageReport_v.fenumber,
dbo.Made2ManageReport_v.fduedate,
dbo.Made2ManageReport_v.fbompart,
dbo.Made2ManageReport_v.fbomdesc AS Shaft
FROM
dbo.Made2ManageReport_v
LEFT OUTER JOIN
dbo.Shaft ON dbo.Made2ManageReport_v.fsono = dbo.Shaft.fsono





>You're welcome.
>
>>More life saving!!!!!!!!
>>
>>Thanks again
>>Jim
>>
>>
>>>There's no IIF() function in SQL Server. You would use CASE function instead.

...
>>>CASE dbo.Made2ManageReport_v.antitip
>>>WHEN 'R' THEN 'RIGHT'
>>>WHEN 'L' THEN 'LEFT'
>>>WHEN 'B' THEN 'BOTH'
>>>ELSE 'NONE' END  AS AntiTip,
>>>...