Return Values to Right AND Left of Delimiter (1 Viewer)

[imtheodore]

I have a large text field I would like to pull out the time from. The field contains a long written response and makes use of a time in the text. The time in in the format 00:00. I need to pull the time out of the text.

I am able to use substring to pull the :00, but I cannot figure out how to get the first part of the time 00.

This is what I am currently using to get the minutes:

SUBSTRING([Field1], PATINDEX('%:%', [Field1]),-3)

The result is :00, I still need the hours so I can have 00:00

Thanks

 

[mdlueck]

This thread looks promising to glean a solution from.

"Parsing a timestamp"
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=142464