Subject | POSITION |
---|---|
Author | Dion Oliphant |
Post date | 2005-02-17T09:06:44Z |
Hi,
Is it possible to find the occurrence of a char in a string using DSQL.
Ie
SELECT SUBSTRING(aWord FROM 1 TO (need to insert a char position here))
from aTable, or will I need to use an SP. Basically I need to split a
string(CSV) into its substrings.
Many Thanks,
Dion.
Is it possible to find the occurrence of a char in a string using DSQL.
Ie
SELECT SUBSTRING(aWord FROM 1 TO (need to insert a char position here))
from aTable, or will I need to use an SP. Basically I need to split a
string(CSV) into its substrings.
Many Thanks,
Dion.