Search a word in a line result of a filtered field from a DataWindow

[RubensLott]

Good morning all!

I have a complicated question here.... complicated to explain what I do need too....
I have a window to search for cities and the cities shown are result of a DataWindowChild filtered by region/state..... OK so far?
Then I need a search script to find a city by writing a part ofthe name instead of writing the name since the begining....
f.ex. I can find "New York" just writing "York" instead of "New Y".... Is that clear???
I tried to use FIND but it doesn't work the way I need....
Can anyone help me? I need a very big tip......

Thanks in advance....

 

[RubensLott]

Good morning.....

I already found a way....
I used the following syntax:

ll_found_row = dw_1.Find("Lower(#2) like '%" + Lower(is_filt) + "%'", 1, 99999)

But thank you all anyway.....

This issue can be closed!