Hi all,

I'm currently building a search field that can search on adress.

Now the adress is stored as multiple attributes in the database. (Street, housenumber, addition, housenumber, city)

When the user searches on a string that contains the street and the housenumber it should return the right records that relate to the search.

However, the user can also search in an different order for example housenumberand than the street. This should give the same results

I could make it (partial) work when i create a string of all adress attributes (and add a space between each attribute) and use the like % + keyword + %. However, than it only works if the user explicitely searches in the order the string is being build. Since it should be possible to search in a different order, this is not optimal.

Any tips on how to do this in an aggregate? Prefer to not use SQL for this in case possible.

Thanks!

Bash Nie