• Another option is the ISNULL function, which I use to remove NULL values from the output.