i search for the names via
select stament as below
name1 abd alkareem or jon kamel.... mean any name have 2 parts at myfield
name2 ali
name3 abd alslam
name4 bani atia

SELECT F4,F1,name1,name2,name3,name4 from x2;
where name4=lcName ;
ORDER by name4;
into cursor crsMyCursor readwrite

thanks


>How would youm search for 'jon kamel' agains those 4 fields?
>
>>
>>many of the Arabic Names have parse name .. ex
>>name1 abd alkareem
>>name2 ali
>>name3 abd alslam
>>name4 bani atia
>>
>>thanks
>>
>>>I still not sure what you are doing. Why do you parse name if you want to search on full name?
>>>
>>>>thank you for reply,
>>>>i try to find the filed name4 as (jon kamel) not as (jon) only
>>>>
>>>>>What arer you trying to do and what seems to be a problem?
>>>>>
>>>>>>
>>>>>>i try to fitch for name as below put the name4 as (jon kamel) mean 2 parts with space between the name.
>>>>>>
>>>>>>

>>>>>>  if LEN(ALLTRIM(thisform.text10.value)) > =3
>>>>>>
>>>>>>     For x=1 to getwordcoun(thisform.text10.value)
>>>>>>
>>>>>>           lcName = getwordnum(thisform.text10.value,m.x)
>>>>>>
>>>>>>  if m.x=1
>>>>>>SELECT F4,F1,name4,name3,name2,name1  from x2;
>>>>>>       where name4=lcName ;
>>>>>>              ORDER by name4;
>>>>>>       into cursor crsMyCursor readwrite
>>>>>>
>>>>>>else
>>>>>>
>>>>>>endif
>>>>>>endif
>>>>>>

>>>>>>thanks