caseSyntax

------------------------------------------
CASE WHEN EXISTS(select doc.id from tbl_Document doc where doc.ProjectID=prj.ID)
THEN 'Yes'
ELSE
'No'
END AS ATTACHED_FILES




-------------------------------------------
SELECT
ISNULL('$ ' + CONVERT(varchar(100), tbl_Contractor.Balance) + ' USD', '$ 0 USD ') as Balance
FROM tbl_Contractor where tbl_Contractor.UserID=@cid

--------------------------------------------

ISNULL('$ '+CONVERT(varchar(100),tbl_Bid.BidAmount)+' USD','N/A')
as BidAmount

--------------------------------------------

isnull(convert(varchar(100),tbl_Bid.DeliveryTime)+' Day(s)','N/A') as DeliveryTime

--------------------------------------------