Tablename : Employee

select name,age,photopath from employee;

I need to re frame the query, ie if the photo path is null, then i need to return photo cloumn which is a BLOB.

photopath - will be <http://www.servername.com/imagename.html>

Thanks.