Yes, this works...

But, I was wondering why the SUBSTR didn't work....

Thanks..


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