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

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