Archives of the TeradataForum

Message Posted: Fri, 03 Sep 2004 @ 17:20:08 GMT

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

Hi Frank,

I have another requirement ,suppose If I want display like this $0.17-$90.99 that indicates a dollar range

I am trying a query like this

     SELECT 0.19 (FORMAT '$zzz9.99') (CHAR(10)) || '-$' || 90.99 (FORMAT '$zzz9.99') (CHAR(10))

but its not workin out

help me

regards,

Prasanna.

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