How to display 'Please select all' at top of Union Query results

[napstar]

I have a dropdown list which has an sqldatasource but I'd like the first item on the list to be "Please Select A Title".I tried using a UNION query :

SELECT MessageTable.Title
FROM dbo.MessageTable
INNER JOIN dbo.PreacherTable
ON
dbo.PreacherTable.PreacherID=dbo.MessageTable.Prea cherID
WHERE dbo.PreacherTable.PreacherID=1
union select Upper('Please select A Title' )

But the result is:
7 People Who Believed In The Anointing - day 2 ses 1
7 Steps To The Anointing In Your Own Company - day 3 ses 1b
Anointing In Your Own Company - day 3 ses 1a
Iron Sharpeneth Iron Loyalty Conference 2009
PLEASE SELECT ALL
The Anointing In Your Own Company - day 3 ses 1a

How do I get the PLEASE SELECT ALL row to be first row in the resultset?

thanks

[Uncle Dickie]

You could try something like the following(I would guess that you can set your drop down to ignore the mySort field so it doesn't show on your form) :

SELECT MessageTable.Title,
       2 AS mySort
FROM dbo.MessageTable
INNER JOIN dbo.PreacherTable
ON
dbo.PreacherTable.PreacherID=dbo.MessageTable.PreacherID
WHERE dbo.PreacherTable.PreacherID=1
UNION
SELECT Upper('Please select A Title' ),
       1
ORDER BY mySort