Expression

[deepakqlikview_123]

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

[#2]

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