I have a column of data with values resembling this: HL7_Result_for_Message_ID_123Q324343.hl7 I need to grab that ID number (in bold), the challenge being that it can be any and all lengths. I have ...
So I've got this temp table in a stored procedure. Set @i = 1 While @i <= 10 Begin If (IsNumeric(Substring((Select SCNumberParsed From #Results), @i, 1))) = 1 Update ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results