MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Help please
Posted by: David Fells
Date: March 28, 2005 07:22PM

The IF function is usually easier to read in a field list in my opinion. There are times when you have to use a case, but when it's a yes/no 1/0 true/false type answer, an IF() will usually do it.

clienttime = IF(WO_TEXT1 = '', 'No', 'Yes')

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Help please
Juan Anders
March 28, 2005 10:40AM
Re: Help please
Juan Anders
March 28, 2005 01:01PM
Re: Help please
Sean Duffie
March 28, 2005 04:16PM
Re: Help please
David Fells
March 28, 2005 07:22PM
Re: Help please
Shantanu Oak
March 29, 2005 01:38AM
Re: Help please
Juan Anders
March 29, 2005 11:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.