ryann
asked on
Sql case statement
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.
SELECT DISTINCT
isnull(Contract.ContractId ,'N/A') as [FormerContractID],
isnull (Contract.ContractOid, 0) as [FormerContractOid]
FROM Contract
left JOIN ContractItem ON
Contract.ContractOid = ContractItem.ContractOid AND ContractItem.IsTerminated = 1
left join
ContractEquipment ON ContractEquipment.Contract EquipmentO id = ContractItem.ContractEquip mentOid
order by [FormerContractId]
It is a varchar(25) column. I need to include the check for isnull on this column.
SELECT DISTINCT
isnull(Contract.ContractId
isnull (Contract.ContractOid, 0) as [FormerContractOid]
FROM Contract
left JOIN ContractItem ON
Contract.ContractOid = ContractItem.ContractOid AND ContractItem.IsTerminated = 1
left join
ContractEquipment ON ContractEquipment.Contract
order by [FormerContractId]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER