Re: Default result

2007-11-24 Thread Dan Nelson
In the last episode (Nov 24), Steffan A. Cline said: > 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 12

Default result

2007-11-24 Thread Steffan A. Cline
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 -