Information générale
Titre:
Strange situation where SUBSTR does not work..
Another strange one today....
I connect to ORACLE and run two statements:
SQLEXEC(h,'select * from standard','standard')
SELECT substr(Language1,1,3) FROM StandARD
However the substr function only gives me the first character in the field...like it's doing a substr(ccc,1,1)
If I do SELECT substr(Language1,2) FROM StandARD i get only the second character in the function
like I was doing substr(ccc,2,1)
I do the same stament on the foxpro version and it works as expected...
The only difference is that it is now a cursor and there are some null values in the data.
However,
SELECT substr(Language1,1,3) FROM StandARD where language1 is not null
Has the same efffect.
Anyone know what's happening here?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement