I am implementing free search text box, which can search data in all columns of tables.
I have created DisplayName column by concatinating two column data with space.
SELECT TOP ALL FirstName||' '||LastName AS DisplayName, UserType, IsActive, RoleName, DOB FROM LISDB.ExternalUsers
Now, in where condition I want to do like search in DisplayName column but it not working.
I have tried both fn CONCAT and || in like query but both are not working for me.