>Have a go at both possible solutions and see whether they work.
>Difficult for me to test since I do not have access to chinese
>
>solution 1)
>

>pStartCode = 'A'
>pEndCode  = 'Z'
>
>select * ;
>    from companytable ;
>    where ( companytable.code between pStartCode and padr(rtrim(pEndCode), len(companytable.code), 'z') )
>

>
>
>solution 2)
>

>pStartCode = 'A'
>pEndCode  = 'Z'
>
>select * ;
>    from companytable ;
>    where ( companytable.code between pStartCode and pEndCode + chr(255) )
>

Z is not necessarily the last character in all languages - in mine, it's ® (z caron) which comes after Z in our alphabet.

While I was using Fox with different codepages, I've discovered that the ISALPHA() function does respect the proper definition of what is a character and what is a digit or punctuation in the current codepage. So, the solution would be

where isalpha(companytable.code)