Thanks a lot - this worked. I used "ORDER BY 3, 2" The 2 allowed the multiple data records in the second select to be ordered by the subcontractor.n ame while still getting the 'PRIME' to stay at the top of the list.

Thanks again!...

I have a sql query that unions two recordsets. It works when I don't try to adjust the ORDER BY clause using the replace function. However, I want to ensure that a certain item in the list always floats to the top. Can someone help me?

Below is the SQL that does not run. Error is "Invalid column name 'name':

Select 0 as [subcontractorID], 'PRIME' as [name]
UNION
Select
subcontractor.s ubcontractorID,...