InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 00:19:50 GMT20http://www.sqlservercentral.com/Forums/Topic773300-145-1.aspxWhy can't you use ORDER BY?try this[code]declare @items1 table (item varchar(100))declare @items2 table (item varchar(100)) insert into @items1 select 'Cost Evaluation Sheet'union select 'Decision Gate 1 Complete'union select 'Involvement Complete'union select 'Statement of Work' insert into @items2 select 1001 select item from @items1union allselect item from @items2order by item[/code]returns[code]1001Cost Evaluation SheetDecision Gate 1 CompleteInvolvement CompleteStatement of Work[/code]Wed, 19 Aug 2009 03:37:13 GMTkevrileyhttp://www.sqlservercentral.com/Forums/Topic773300-145-1.aspxIn select query values with space appended takes higher precedence than normal characters . How to overcome this . I.e the result is like this as shown below but i want 1001 to come on the top. Since i am using union all cannot use order by. Cost Evaluation Sheet Decision Gate 1 Complete Involvement Complete Statement of Work1001Wed, 19 Aug 2009 03:09:11 GMTnazmunnisa_g