My bad. I had this on a to do list but I don't need it because in fact I am not storing the age I am calculating it when I need it.
Dan on 7/16/03 13:24, Simon Boddy at [EMAIL PROTECTED] wrote: > 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
