Damanindahaus
New Member
Hey bros,
I have a little syntax problem. I am already searching for about 2 hours what string and count functions Progress has. But I'vent found enough. So I thought, maybe you can help me.
What is the real Progress Syntax of this:
SELECT SUBSTRING('12;3', 1, (SELECT CHARINDEX(';', '12;3')-1)) AS Column1,
SUBSTRING('12;3', (SELECT CHARINDEX(';', '12;3')+1), (SELECT LEN('12;3'))) AS Column2
FROM tablename
Explanation:
The Select should give me 2 columns. In the first column I wanna have '12' of the text '12;3'. In the second, I wanna have '3'. Is this possible?
best regards,
Daman
I have a little syntax problem. I am already searching for about 2 hours what string and count functions Progress has. But I'vent found enough. So I thought, maybe you can help me.
What is the real Progress Syntax of this:
SELECT SUBSTRING('12;3', 1, (SELECT CHARINDEX(';', '12;3')-1)) AS Column1,
SUBSTRING('12;3', (SELECT CHARINDEX(';', '12;3')+1), (SELECT LEN('12;3'))) AS Column2
FROM tablename
Explanation:
The Select should give me 2 columns. In the first column I wanna have '12' of the text '12;3'. In the second, I wanna have '3'. Is this possible?
best regards,
Daman