@KevinJ of Kansas Thanks Keving! That did the trick NVL(manufacturer, '') AS manufacturer worked like a charm!