I have a text field (field named "BiographyText" in the "Employs" table) in SQL Server 2008 which stores KPI target figures:
rebfirst60,
reifirst1.3,
retfirst50
The first target is 60, for RebFirst, the second is 1.3 for ReiFirst and 50 for the third, RetFirst.
I want to be able to return the 3 different numerical values, as these would be deemed the targets for each kpi for a certain employee.
I am having a complete mind block trying to figure out the best way to do this, any advice/help?
Overall I am trying to find the kpiname ("rebfirst") and then retrieve the next 2 characters/digits
I tried the following, but it errors on function 2 of the first substring, as it is non-numeric:
select SUBSTRING(biographytext,SUBSTRING('rebfirst',1,2),2) from employs
Thanks