Archives of the TeradataForum

Message Posted: Fri, 08 Dec 2006 @ 14:16:18 GMT

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

Prahlad:

The thoughts so submitted to you so far require converting the numeric value to a character first. This is not a cheap option when it comes to system resourses. Using math is always faster. So, I suggest the following:

     sel dec_column/1000 mod 10  /*  date math to extract single digit  */
     from dec-table;

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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