I want to remove special character in sql query

See more:

SQL

server

i have a field time_of_arrival there i am capturing hour and minutes the field name is fldarrival
(i.e)

08-44
8-45
10-5
10-05

Here i am writing query to split hour and minutes here only i am getting confusion. my query is :

select substring(fldarrival,1,2) as HH from dbo.CS_Initial_Assessment
select substring(fldarrival,3,2) as HH from dbo.CS_Initial_Assessment

my output is

HH  MM
08  44
8-  45
10  -5
10  05

Expected output:

HH  MM
08  44
 8  5
10  5
10  05

Here i want to remove special character. Can any one pls suggest how to go about it.

Regards,
Vinoth