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.

SUBSTING function is giving error in Teradata Studio which was working fine in Teradata SQL Assistant.
My Query is like this : SEL SUBSTRING('ABC',1,2)
I do not want to use SUBSTR instead of SUBSTRING as it involves making changes in a lot of Queries. Please suggest a work around for this issue.
 
Thanks!
Anirudh

hi
 
have few questions reg substr & substring
 
a. which one is ANSI compliant?
b. whats th difference btween two?
c. which one should be used?
 
Natasha

Please explain how this wotks.
SEL SUBSTR(CAST(12345 AS VARCHAR(5)),1,3)
This gives "123" as OP
whereas
SEL SUBSTR(12345,1,3)
gives only "12", why does when passing integer/number it always reduces one explictly and gives output?