Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to implement the following:-
1. Where the time_of_receipt field in straight table is blank I want to replace with the word 'PNR' in the image attached.
maye be :
if(len(trim(time_of_receipt))<1,'PNR',time_of_receipt) as time_of_receipt,
maye be :
if(len(trim(time_of_receipt))<1,'PNR',time_of_receipt) as time_of_receipt,