Ramco Ramco

Ramco Ramco

  • 428
  • 3.5k
  • 562.2k

Null Value then '' should be shown

Nov 16 2022 6:18 AM

Hi

I have below select statement . I want if ResubmitDate - SentBackdate is null then "" should be shown

(select DATEDIFF(d,Min([SentBackDate]),Max([ReSubmitDate])) from [PRQS].[dbo].[View_Capex_StepWiseApprovalDetail] where EntryCode=L.[PR] ),
 

Thanks


Answers (1)