return value 'no row' if max query return a NULL

I have a table. From that I need to return Max value of a field. If that row is empty or if it doest satisfy some conditions the query will return NULL. I need to return NO ROWS if the max returns a NULL. How can i do it? I have tried IS NULL, IF,COALESCE But I am not able to get what i need.

Sorry, it was my mistake. I dont mean to say the word 'NO ROWS', More clearly i dont want to get any rows(no rows should be returned) if it returns NULL. I apologies again for my mistake.