Can this work?
the values in dbo.Made2ManageReport_v.antitip are R, L, B, N for right,
left, both, and none.
If this works can I use a case statement in a SQL statement.

SELECT
dbo.Made2ManageReport_v.fsono AS SalesOrderNumber,
dbo.Made2ManageReport_v.carriagetype,
dbo.Made2ManageReport_v.angle,
dbo.Made2ManageReport_v.channel,
dbo.Made2ManageReport_v.vendor,
dbo.Made2ManageReport_v.sections,
dbo.Made2ManageReport_v.passthrough,
dbo.Made2ManageReport_v.starter,
dbo.Made2ManageReport_v.adder,
dbo.Made2ManageReport_v.standar,
dbo.Made2ManageReport_v.xright,
=====> IIF(dbo.Made2ManageReport_v.antitip="R","RIGHT","LEFT") 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