>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?

Have you tried: SELECT left(Language1,3) FROM StandARD ?