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?