Unanswered: Sql Query for multiple texts - Which Forum
I am querying a varchar column.
My goal is to save the percentage following 'ejection fraction' as part of the query results.
Text being queried looks like>> LEFT VENTRICLE: Overall systolic function appears normal. Fractional shortening is 43%. Estimated ejection fraction is 65%-70%.
I need to meet the 2 conditions: a) Find 'LEFT VENTRICLE' and b) find 'ejection fraction'. If I use a '%' wildcard to find 'LEFT VENTRICLE', can I\should I substring? or use another function to find the 'ejection fraction'?
Advice please. Also which forum should this go to?