Archives of the TeradataForum

Message Posted: Fri, 03 Sep 2004 @ 18:15:45 GMT

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

"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 "

You could try this:

     select c from (
      SELECT 0.19 (FORMAT '$zzz9.99') (CHAR(10))  a ,  90.99 (FORMAT '$zzz9.99') (CHAR(10)) b, a || ' -- ' || b c ) dt

Paul

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