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,
...

>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