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/
