Try with Charindex

DECLARE @StartTime VARCHAR(MAX),@X XML

SELECT @StartTime = '7:00 AM

12:30 PM'

DECLARE @tbl TABLE

(

ID INT

)

INSERT INTO @tbl

SELECT TOP 100 ROW_NUMBER() OVER(Order by s.object_id)

from sys.objects s , sys.objects si

select LTRIM(SUBSTRING(@StartTime,ID,CHARINDEX(CHAR(13),@StartTime+CHAR(13),ID))) from @tbl

where CHARINDEX(CHAR(13),CHAR(13)+@StartTime,ID)=ID