widget for adress search

[Anonymous]

Hello,

i'm using the search widget of the fusion web layout with a concat expression in order to search for adresses (road&number). This works fine when the user knows the right spelling of the road. So an Input like "Neumarkt 5" works fine, also something like "neum" prints out a list of all adresses including "neum". But when the input is like "neumarkt 5" it doesnt work .

Here is the code i'm using:

Lower(concat(concat( Name , ' ' ),  ADR ) ) LIKE Lower('%25$USER_VARIABLE%25\') 

 How do i have to change the code in order to make an input like "neum 5" work in this case?

best regards