I want to be able to parse an 'id value' from a description field.
So values for this id are in bold and underlined for you. They will always be after the : and before the E of Emplid.
example 1. REQUEST_ID:RV3-5 EMPLID:2005078 RDC:RA,0,A
example 2. REQUEST_ID:13 EMPLID:1001716 RDC:RA,0,A
Is there a way you can do this in sql?
Right now the creator of the query is doing this:
AND G.REQUEST_ID = SUBSTRING(B.EOAWDESCR , 13 ,2))
This will not work for the RV3-5 ...
Any help would be greatly appreciated.