Archives of the TeradataForum

Message Posted: Thu, 07 Oct 2004 @ 22:24:26 GMT

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

Here another possibility, for what it's worth. I'm havin' fun now.

     select databasename, accountname
     from dbc.databases
     order by case when accountname = '$M2$&LAdhoc' then
     substr(accountname,7) else substr(accountname,6) end;

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