I am looking to retrieve information from a field, but am having troubles getting exactly what I want. The information I want has no set order and I am also looking for two different things. Here is an example of the information I am working with.
|PEvent| PDate | PDescription | | 3 | 2014-11-21 | Padding, 90 Series, Stage, SF550 | | 4 | 2014-11-21 | Padding, 45 Series, 144 Stage SF90, 15 spor, AR | | 5 | 2013-03-06 | 400 Series, 96 STAGE RE FLEX 30 | | 6 | 2015-01-09 | Padding, 20 Series, 13 Stage SF 550, Housing |
What I want to get is SF and the number and FLEX and the number that follows it, in these cases SF550, SF90, SF 550 FLEX 30. I would also like to get FLEX and the number that follows it. The problem I am having is that there are so many differences in the data. I cannot say 10 spaces from the left since it is not always 10 spaces. I have the same problem from the right. The other issue I have is that sometimes SF and FLEX will be right against the number where other times there will be a space in between them.
I have created a SQL Fiddle sample database with more records for testing.