Good Morning Team,
Hope all is well
Hoping you can help me. I have a column in a table called indicator. (Data type : NVarchar (80)
Within this column i have some numbers the length of this number is 6 characters in length. The total the Length of indicator column can vary from 0 to 56 Characters long.
Below is small Subset of the data. What i would like to do is produce another column which extracts the numbers from indicator column.
Row 1 : GB-JP--123456
Row 2 : 401015 - GB-NA
Row 3 :
Row 4 : 999999 - LX - UK
I tried the following query but i get this error
Substring (Indicator, PATINDEX('%[0-9]%', Indicator), LEN(Indicator))
However i am presented with the following error
"SUBSTRING": invalid identifier"