Hi there,
>for example, SQL7 will order a column with NULL values at the top, while
>Oracle will order them at the bottom.
>
> sorted by MSSQL7: NULL, NULL, NULL, 1, 2, 3
> sorted by Oracle: 1, 2, 3, NULL, NULL, NULL
>
In SQL7 server: Null values are treated as the lowest possible values.To
reverse this you use DESC ASC
>case sensitivity also throws off ordering, oracle will order all
>uppercase before ordering lowercase:
>
> sorted by MSSQL7: jones, Smith, thomas, White
> sorted by Oracle: Smith, White, jones, thomas
>
SQL 7 has the following ordering options:
Dictionary order, case-insensitive
Binary2
Dictionary order, case-sensitive
Dictionary order, case-insensitive, uppercase preference
Dictionary order, case-insensitive, accent-insensitive
Some Oracle stuff
http://www.cffaq.net/cf_and_oracle.cfm
http://www.cffaq.org/procparam.htm
Justin MacCarthy
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
