trying to get a result if another isn't returned.

[IBazz]

Hi,

I am querying a table for a specific range of rows. If the query returns nothing, I want another range of rows to be selected. Either it returns >0 specific rows or it is to return a (default) specific 6.

Should I do this in my server side language or can I do it all in the query? I am wondering about case where...but wouldn't it check for a zero return for each row rather than for the whole query?

bazz

[IBazz]

Just to clarify...

here is the current query

select 
                                bt.condition_name
                              , bt.condition_details 
                              from booking_terms as bt
                               where business_id = ?

if there is nothing returned at all by the query, I need to output the default values. if just one record is returned, I need no more to be done.

bazz