Help Me select statement

[kandukurip]

Good Morning

Please Help Me. I have one table with 1 fields (details). I want to find out a particular number in the data.

sample data
Details(field Name)
NO prior tx,collapsed 4 min ago,unconscious,NOT breathing,NO pulse,chest .


My problem is I want to find out time after the next to collapsed time. In the above scenario I want result like 4 min.

I will appreciate your reply.

Have a nice day

Mike

 

[r937]

select substr(details
, charindex('collapsed ',details)+10)
, 6 )

searches for the string 'collapsed ' and takes the next 6 characters after it

will not find 'collapsd ' or 'collapse '

rudy

 

[kandukurip]

Thank Rudy

Thank you very much........