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.