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
---------------------------------------------------------------