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/
