0 - 1 of 1 tags for variable length substring
Variable length substring with multiple delimiters

Hi,
I have below variables in my result set. These are result of an substring function.

734746/Chi
1435919?c=
762799?c=E
710632?c=E
20784/T23

I want to get only the numeric values before first delimiter(/, ?). So the result set should look like this.

By Nikhil_Teradata, 22 Jul 2015 | Tagged: substr substring variable length substring | 4 comments