Is there a way to change mons in interval::text to the full word months without resorting to "replace(aninterval::text,'mon','Month')"? If it can handle locales as well that would be good (but I could live without it). klint. +---------------------------------------+-----------------+ : Klint Gore : "Non rhyming : : EMail : kg@xxxxxxxxxxxxxx : slang - the : : Snail : A.B.R.I. : possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---------------------------------------+-----------------+