Archives of the TeradataForum

Message Posted: Mon, 13 Sep 2004 @ 17:07:30 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Just another thought regarding the age: YEAR without precision defaults to two digits so customers of 100+ years of age could be another age group to look at with this type of error. Try YEAR(4) instead of just YEAR in your original statement!

Victor

	<Prev	Next>		<<First	<Prev	Next>	Last>>