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/
