Hi,

Sorry Sowbhari,

its working.

DECLARE @StartTime VARCHAR(MAX),@X XML

SELECT @StartTime = '7:00 AM <br/> 12:30 PM'

SELECT @X = CONVERT(XML,'

' + replace(@StartTime,'<br/> ','</br>

') + '</br>')

SELECT x.i.value('.','varchar(max)') AS [StartTime]

FROM @X.nodes('//br') x(i)

Thanks.