Returning a default value in SQL when no rows found
cubmarJun 13 2008 — edited Oct 4 2013Hi
How can change my SQL to return a default value if no rows are found?
Eg:
select text from text_file where criteria=met
If no rows are found, I would like text to contain '**Empty' for example
Thanks