Returning a partial string

[jda]

>
>  > Then in my code, I used:
>>
>>
>>  select firstAuthorSortMethod,thedateSortMethod, * from thereferences
>>  where hit>0 ORDER BY firstAuthorSortMethod,thedateSortMethod
>>
>>
>>  (I also tried ORDER BY 1,thedateSortMethod)
>>
>>  The result is not sorted at all (or at least there is no pattern I can see).
>>
>>  What am I doing wrong?
>
>Hard to say.
>
>Can you send us some test db ?
>
>Does that methods show correct values in viSQL or Vstudio ?
>

No, in viSQL it seems the values for the method are all NULL.

Maybe Valentina doesn't like chr(13) for the return character. I 
tried \r, but that didn't work, either. What should it be?

Jon