Hi there, Why do you want to store age? Would it be feasible to calculate age each time you want to use it? SQL Server has all the necessaries for writing expressions in your select clause and your criteria.
Regards Simon. -----Original Message----- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: 16 July 2003 18:10 To: [EMAIL PROTECTED] Subject: Witango-Talk: Date to Age SQL or WiTango I have a table with birthdates and ages. I would like the ages to calculate automatically so they update when needed. I guess I could run a cron job and use a taf to update them all. But SQL 2000 has a place for formula. I just don't understand how to use it. Dan -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ******************************************************************** This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by LGCSB (Local Government Computer Services Board). Any attachments have been checked by a virus scanner and appear to be clean. Please ensure that you also scan all messages, as LGCSB does not accept any liability for contamination or damage to your systems. ******************************************************************** ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf