List:General Discussion« Previous MessageNext Message »
From:Steffan A. Cline Date:November 25 2007 3:38am
Subject:Default result
View as plain text  
Is there anything I am missing that will allow me to return a default row if
the sought after row is not found?

For example :

Select * from table1 where column1=1234

If 1234 is not found, row1 would be returned instead.
If 1234 is found then that is the row returned.


Thanks

Steffan

---------------------------------------------------------------
T E L  6 0 2 . 7 9 3 . 0 0 1 4 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline 
Steffan@stripped                             Phoenix, Az
http://www.ExecuChoice.net                                  USA
AIM : SteffanC          ICQ : 57234309
YAHOO : Steffan_Cline   MSN : steffan@stripped
GOOGLE: Steffan.Cline             Lasso Partner Alliance Member
---------------------------------------------------------------



Thread
Default resultSteffan A. Cline25 Nov
  • Re: Default resultDan Nelson25 Nov