Insert to the frist row 1

[xxing]

Hi I have a table that has the following data:

Column1
Apple
Banana
Orange
Pear

Column1 is in alphabetical order

I would like the following:

Column1
Select All
Apple
Banana
Orange
Pear

Thank you
Mark

 

[RiverGuy]

I'd opt to put the logic in the application, however if you are unable to do so, then the following will work. Note the space prefix before "Select All" to aid in the ORDER BY clause.


SELECT ' SELECT ALL' AS Column1
UNION ALL
SELECT Column1 FROM YourTable
ORDER BY Column1

 

[xxing]

Thank you Riverguy for the post. A star for you!!

Regards
Mark

 

[RiverGuy]

No prob.