> I want to call a function using a column of a table as the parameter and > return the parameter and function results together. > The problem is, when the function returns an empty row my select statement > that uses the function returns an empty row as well.
Hello, not sure if it makes sense in your context, but something like this could do the job: WITH SEL AS ( Your Query) SELECT * FROM SEL UNION ALL SELECT 'nothing found' WHERE NOT EXISTS ( select * from sel); regards, Marc Mamin
