If I understand you, you want to have a default value to be returned whenever no value is specified.
Select order_nbr, field1, field2, field3
where order_nbr = isnull(@Ord_nbr,'xxxxxx')
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills