How would I formulate a case statement in this select, which would move in 'N/A' if the "Contract.ContractId" is = spaces.
It is a varchar(25) column. I need to include the check for isnull on this column.
isnull(Contract.ContractId,'N/A') as [FormerContractID],
isnull (Contract.ContractOid, 0) as [FormerContractOid]
left JOIN ContractItem ON
Contract.ContractOid = ContractItem.ContractOid AND ContractItem.IsTerminated = 1
ContractEquipment ON ContractEquipment.ContractEquipmentOid = ContractItem.ContractEquipmentOid
order by [FormerContractId]