SEARCH function does not work on fields

SEARCH({Name}, “TEXT”) the easiest possible function does not work.
In fact SEARCH does not work on anything but static strings, ie. SEARCH(“text”, CONCATENATE({Name},st")) will not work either. Comparing two static strings to each other is not really useful.

There are no alternatives to SEARCH function. This is a crucical deficiency, please address soon!
thank you!