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 ?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only