Use a primary and secondary sort field. Primary controlled by "Package" and the secondary by the alphabetic order of the other values.
insert into sortTest (name) values('Package')
insert into sortTest (name) values('Crime')
insert into sortTest (name) values('DIC')
insert into sortTest (name) values('Aircraft')
insert into sortTest (name) values('Apartments')
select
name,
case when name like 'Package%' then 0 else 1 end as PrimarySort,
case when name like 'Package%' then null else name end as SecondarySort
from sortTest
order by PrimarySort Asc, SecondarySort Asc
name PrimarySort SecondarySort
Package 0 NULL
Aircraft 1 Aircraft
Apartments 1 Apartments
Crime 1 Crime
DIC 1 DIC
If there are multiple values starting with "Package" and you want ordering within them then the secondary sort selection becomes:
select
name,
case when name like 'Package%' then 0 else 1 end as PrimarySort,
name as SecondarySort
from sortTest
order by PrimarySort Asc, SecondarySort Asc
name PrimarySort SecondarySort
Package 0 Package
Package A 0 Package A
Package B 0 Package B
Aircraft 1 Aircraft
Apartments 1 Apartments
Crime 1 Crime
DIC 1 DIC
Of course you don't need a separate SecondarySort column now as it's just name, but using it makes your intentions clear and it means if your sort rules change you can change server side code with minimal (possibly no) disruption to client code.
Throw away the package value(s) and re-run the select.
delete from sortTest where name like 'Package%'
select
name,
case when name like 'Package%' then 0 else 1 end as PrimarySort,
name as SecondarySort
from sortTest
order by PrimarySort Asc, SecondarySort Asc
name PrimarySort SecondarySort
Aircraft 1 Aircraft
Apartments 1 Apartments
Crime 1 Crime
DIC 1 DIC
And in your VB if you use a dataview to feed the output rather than the dataset and you want to make doubly sure that this order is preserved..
Dim dv as DataView = New DataView(myDataSet.Tables("myTable"))
dv.Sort = "PrimarySort Asc, SecondarySort Asc"
...but I don't think that'll be necessary unless you are allowing users to remove rows from the datatable client-side.