create new var conditionally

[Sultana]

I want to add a new var as Guarantor Dependent at origination (85) or after origination (95), How do I write the code. 

select  
b.mktDesc,  
a.acctno,  
a.acctSName,  
a.balToday,  
a.commitment,  
a.restructFlg,  
GuarantorDep = '',  
a.PD,  

[r_behata]

Not exactly sure what you are looking for .  But, If you want the New Var to have a different value depending on the values in origination, you may use a case statement.

case when 
	origination=85
	then  'A'
	when
	origination=95
	then 'B'
End as GuarantorDep

Replace the values 'A' and 'B' as per your requirement.