Maybe this is a strange question, but is there a way to add a single row (or several) to the return set of a SELECT statement?Example:I want to populate a drop down list with SELECT EmpID ...

Power Query transformations can assist in splitting data into rows, based on various factors such as delimiter, text patterns, and data types.

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.