Archives of the TeradataForum

Message Posted: Fri, 08 Oct 2004 @ 23:43:37 GMT

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

And a small variation on the theme for all the old Oracle guys who like numbers:

     SELECT databasename,
            CASE
               WHEN accountname = '$M2$&LAdhoc'
                  THEN SUBSTR(accountname,7)
                  ELSE SUBSTR(accountname,6)
             END
       FROM dbc.databases
      ORDER BY 2;

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