John You will have to soemthing similar to Oracle Decode Martin- ----- Original Message ----- From: "John Mistler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, October 10, 2004 9:23 PM Subject: Enforce value on select
> Is there a way to force SOME value to be returned from a SELECT query when > the result is empty set? For instance: > > SELECT nameColumn from theDatabase WHERE rowID = 5; > > (when no row has ID "5") > > result --> empty set > > I would like for it to return some value, such as '' or 0 . . . > > Thanks, > > John > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]