View Single Post
  #4 (permalink)  
Old September 23rd, 2004, 04:06 AM
pgtips pgtips is offline
Friend of Wrox
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post

you can get around this limitation by putting the SELECT DISTINCT part into a view. Then you can just do SELECT * FROM YourView WHERE ... ORDER BY <<your dynamic part>>
Reply With Quote