Sorry, try again

http://www.sqlserverfaq.com/content/forum/MsgForumFrame.aspx?PN=1&FID=0&R=Y&MID=192826&GUID=&SRHAUT=&STXT=&BCK=&P1=&P1N=">

http://www.sqlserverfaq.com/content/forum/MsgForumFrame.aspx?PN=1&FID=0&R=Y&MID=192826&GUID=&SRHAUT=&STXT=&BCK=&P1=&P1N=

Well , here is where I posted the original question, and you can see the answer , I must give credit and thanks, to Simon Sabin for the answer.

Dave

Hi, thanks again, this worked, dont know why,

Thankyou

Dave

ORDER BY

CASE @OrdSeq WHEN 1 THEN customername ELSE NULL END asc,

CASE @OrdSeq WHEN 2 THEN customerpo ELSE NULL END asc,

CASE @OrdSeq WHEN...

thanks winash, I will give it a try, what does the mi do ?