SELECT .... ,'ON VESSEL "' + VESSEL.NAME + '" FROM ' + ORIGIN.NAME + '/' + ORIGIN.COUNTRY_NAME + 'TO' + CASE ISNULL(SHIP.TRANSSHIP_PORT_ID_1,0) WHEN 0 THEN '' ELSE PORT1.NAME + '/' + PORT1.COUNTRY_NAME + CASE ISNULL(SHIP.TRANSSHIP_PORT_ID_2,0) + WHEN 0 THEN '' ELSE ' AND TO ' + PORT2.NAME + '/' + PORT2.COUNTRY_NAME END + 'IN TRANSIT TO' END + DESTINATION.NAME + '/' + DESTINATION.COUNTRY_NAME FROM ....
CASE condition WHEN test AND A = B THEN
test
SELECT X = CASE WHEN Test = 0 AND A = B THEN OneValue ELSE OtherValue END, ...
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)