Skip to Main Content

Returning a default value in SQL when no rows found

cubmarJun 13 2008 — edited Oct 4 2013
Hi

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Nov 1 2013
Added on Jun 13 2008
19 comments
143,065 views