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