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/
