>Dear Sir/Madam
>
>I am using ATCLINE() command to search a string in a memo feild and then displya all the records that have that string in the memo feild. But I get my result in unordered manner. As memo feild cannot be index is there is any way by which I extract first few character of memo field and then replace them in a
>another field which is a character field and index and sort my records according to that field. Which will give what i want.
>
>Please advise if there is less complicated or simpler solution is there or not.
>
>Or some modification in my idea to make it simple.
>
>Urgent reply requested.
>
>Thanks in Advance.
>
>
>Rahul
Something like :
select notes, mline(notes,1) from employee ;
where notes like '%degree%' ;
order by 2
?
Cetin