Ramco Ramco

Ramco Ramco

  • 442
  • 3.4k
  • 524k

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)