From: Steffan A. Cline Date: November 25 2007 3:38am Subject: Default result List-Archive: http://lists.mysql.com/mysql/210181 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit 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 ---------------------------------------------------------------