Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Can you please tell me how below expression will work.
if(isnull(DATE_OF_OFFLINE)=0,('MBX000'&CHASSIS_NUMBER)) as ASSM_CHASSIS_NUMBER,
Thanks,
Deepak
As per your expression
DATE_OF_OFFLINE is not null then 'MBX000'&CHASSIS_NUMBER this data will store as ASSM_CHASSIS_NUMBER
Isnull() --> True ---> returns --> -1
--> False ----> returns --> 0