G'day Alastair, I do not know if the following data is relevant or not but here it is.
At 05:31 PM 15/10/2001 +0100, you wrote: >Secondly, when using the function IFNULL I want to return a null in a >variable if the tested column is null and perform a calculation if it is >not null. I have column in one of my tables that is only populated with a date when a bill is fully allocated for and therefore able to be disbursed. When I was doing lookups based on the value being null or not for a record set they took a long time. I installed a computed column in the table (for a variety of reasons, rather than a view) that returns a result set MUCH faster than checking the date. The computed column is: (IFGT(DateCol,'01/01/1000',1,0)) Good luck. >If I use (IFNULL(Column, -0-, (Column + 2) )) I get an error or with >(IFNULL(Column, Null, (Column + 2) )) I get a zero when the column is null >and the calculation is fine when the column is not null. > >The column is actually a date column and the calculation is slightly more >complicated than the example and returns an integer. > >I want to display nothing in the variable field if there is nothing in the >column and only show the result when there is one. > >Any ideas anybody? > > >Thanks in advance for any enlightenment, >Regards, Alastair. > > > >A D B Burr, >St. Albans, UK Warmest regards, Tom Grimshaw coy: Just For You Software tel: 612 9552 3311 fax: 612 9566 2164 mobile: 0414 675 903 post: PO Box 470 Glebe NSW 2037 Australia street: 3/66 Wentworth Park Rd Glebe NSW 2037 email: [EMAIL PROTECTED] web: www.just4usoftware.com.au This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses.
