Can you do an order by  to where it is ascending, but I want nulls to be at
the bottom instead at the top.

Dianna

You could include the column you are ordering by twice in the select
statement. In one of them replace the column with the isnull(column,
99999999) or some other artifically high number. Order By the column with
the ISNULL() function, but reference the other one in code.

--
David Gugick
Intrinsic Design, Inc.
Coefficient - Database Analysis for Microsoft SQL Server
http://www.idisoft.com

Check out my Dec 1999 article on this topic in SQL Server Professional:

http://www.pinnaclepublishing.com/SQ/SQmag.nsf/0/E217143728E982B88525...
8B877

--
   Tom

----------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
Columnist, SQL Server Professional

Toronto, ON Canada
www.pinnaclepublishing.com/sql
www.apress.com
---
Can you do an order by  to where it is ascending, but I want nulls to be at
the bottom instead at the top.

Dianna

Hi,

I have several parameters passed to a stored procedure. Due to what value
the parameters have I would like the sortorder to be different by using the
Order by clause. How is this done in a smart way? Now the stored procedure
contains alot of code.

Example:

                            from table
                            order by a, b, c

                            from table
                            order by c, b, a
etc.

Regards,
Wenche

Use dynamic SQL to build the query and use sp_executesql to execute it.

--
Tony Rogerson SQL Server MVP
Independant Consultant
Torver Computer Consultants Ltd
www.sql-server.co.uk [UK Independent SQL Server User Group; FAQ; KBase
etc..]

try...

select a,b,c
from tablename

 when 1 then a
 when 0 then c end,
 b,

 when 1 then c
 when 0 then a end

hth.

-oj