Return a Sorted List with a Wildcard Character

Ignition
1

I want to return a sorted list of the lines in a particular facility. I want the list to be sorted by line number in ascending order but I want an ‘*’ at the top to indicate a wildcard or Select All. Currently, I have the following on a drop down box:

Select 
	'*' as Line
FROM 
	Equipment  
UNION

SELECT 
	ltrim(str(Line))
FROM 
	Equipment 
WHERE 
	Location = '{Root Container.Loc}'

This is fine except it sorts the list as strings so Line 10 appears between Line 1 and Line 2.

Anyone done this before or have any ideas??

2

I have done this sort of thing before.
Try something like this:

SELECT t.Line
FROM
   (Select
      '*' as Line, 1 as SortOrder
   FROM
      Equipment 
   UNION
   SELECT
      ltrim(str(Line)), 2 as SortOrder
   FROM
      Equipment
   WHERE
      Location = '{Root Container.Loc}') t
ORDER BY
   t.SortOrder, t.Line