Yes, that's easy, but try it in a report, or an SQL statement! Dennis
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Albert Berry Sent: Monday, November 25, 2002 3:42 PM To: [EMAIL PROTECTED] Subject: RE: IFIN function possibility OK, but you can do the following now. NB you still need the declarations for the function, only the IF block replaces the IFIN. SET VAR arg1 TEXT = 'Mr' SET VAR arg2 TEXT = '(Ms,Miss,Mrs,Mme,Madam)' SET VAR arg3 TEXT = 'FEMALE' SET VAR arg4 TEXT = 'MALE' SET VAR arg5 TEXT IF arg1 IN .arg2 THEN SET VAR arg5 = .arg3 ELSE SET VAR arg5 = .arg4 ENDIF "Dennis McGrath" <[EMAIL PROTECTED]> wrote: >Yes, but IFIN is a natural extension to the existing logical functions. > >I prefer the built in functions to stored procedures as they are lots >faster. �One does not have to retrieve the stored procedure from the >database every time the function is called. > >I have also requested that enhancement. > >Dennis McGrath > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On >Behalf Of MikeB >Sent: Monday, November 25, 2002 2:02 PM >To: [EMAIL PROTECTED] >Subject: Re: IFIN function possibility > > >You can pretty easily do this with a stored procedure. �Think about it. > > >----- Original Message ----- >From: "Duey Heffelfinger" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Monday, November 25, 2002 2:32 PM >Subject: IFIN function possibility > > >> Good Morning, >> >> Unfortunately I haven't had time to be a beta tester for the new >> versions, but I do have a function request that might help someone >> beyond just me. �If you are a beta tester and would find it useful >> would you please submit the idea for me? �Thanks! �Here's the >> function: >> >> �If arg1 is IN arg2list return arg3, otherwise return arg4. >> �(IFIN(arg1,arg2list,arg3,arg4)) >> >> This could easily be used in a select statement for example: >> >> SELECT (IFIN(title,'Mrs,Ms,Miss','Female','Male')) + >> � FROM tableview >> >> Would display Male or Female based on the IFIN list. �Otherwise you >> have to use 3 IFEQ functions to accomplish the same thing. >> Occasionally my statements have gone over the limit, so I end up >> looking for creative ways to accomplish this type of statement. >> >> Duey >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >> + � � � �Duey Heffelfinger, Director of Computer Services >> + >> + E-mail: [EMAIL PROTECTED] � � � � � � � Dana College >> + >> + Phone : 402-426-7289 � � � � � � � � � � � �2848 College Drive >> + >> + � � � � � � � � � � � � � � � � � � � � � � Blair, Nebraska �68008 >> + >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >> + If you can dream it, it can come true! >> + >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >> >> ================================================ >> TO SEE MESSAGE POSTING GUIDELINES: >> Send a plain text email to [EMAIL PROTECTED] >> In the message body, put just two words: INTRO rbase-l >> ================================================ >> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >> In the message body, put just two words: UNSUBSCRIBE rbase-l >> ================================================ >> TO SEARCH ARCHIVES: >> http://www.mail-archive.com/rbase-l%40sonetmail.com/ >> >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
