In Access I can use:
strParam1 & (', ' + strParam2) & (', ' + strParam3)
Using the + will return null if the param part is null (no comma will appear)
I am trying to do the same in a Stored Procedure. The closest I got was:
(isnull((', '+ Case When EstimatedCloseDate is null then
'No Close Date' end),'') + isnull( (', ' +
(Case When TotalContractAmount is null then
'No Contract Amt' end)),'') + isnull(( ', ' +
(Case When (NeedsUnits=1 and (NumberOfUnits is null or UnitCost is null)) then
'Missing Units' end)),''))as MissingItems
and I was going to try and find the code that will strip out the first two characters, but there has got to be a cleaner way...
Thanks in advance.