CONCAT(ISNULL(NES.NumberOfNomination, ''), ' / ', ISNULL(TP.NoOfSeats, '')) as Seats,
当TP.noOfseats
0
时,我希望查询中的列为空。
您可以使用case
表达式:
CASE TP.noOfseats
WHEN 0 THEN ''
ELSE CONCAT(ISNULL(NES.NumberOfNomination, ''),
' / ',
ISNULL(TP.NoOfSeats, ''))
END AS Seats
CONCAT(ISNULL(NES.NumberOfNomination, ''), ' / ',
ISNULL(CASE WHEN TP.NoOfSeats = 0
THEN ''
ELSE TP.NoOfSeats END, '')
) as Seats,