Hi, I am trying to write an IF statement which will perform the following.....
Here is an example of the results in the table....
Name Exd Name RESULT
HMAA USA USA HMAA USA
HMIT ITL ITL HMIT ITL
HMTT LOG HYT HMTT LOG (HYT)
LTYS LTT FYM LTYS LTT (FYM)
TTTT FFF PPP TTTT FFF (PPP)
FDSE FGR FGR FDSE FGR
The results should be displayed as follows
HMTT LOG (HYT) -----as the two names are different I wan to display the Exd NAme in brackets), however when
HMAA USA , and the Exd Name is also USA - I only want to display the 'Name', not the Exd Name.
Is this possible in a IF statement....This is my script, as you can see it has the name + Exd Name, however above I would like to incorporate an IIF statement in here to only display as per the above logic.
.[name] + ' ' + '(' + rnl.[Exd Name] + ')' as 'Vessel'
resultsIB RNL (nolock)