Table Filter with string as column name

[jimjojac]

Hallo
I want to use Table Filter function where the column name is a string because it can change between different tables. The code looks like:
Table1.Filter("name LIKE '*" & searchS & "*'") where "name" is in this case the real column name. It works fine, but I want it to use like:
Table1.Filter(Table1.ColName(0) Like ....), or

str=Table1.ColName(0)
Table1.Filter(str Like ...)
Is it possible? And if, how is the syntax to make it work?

Thanks

 

[nicolasWhite]

You should use the following syntax:

table1.filter(table1.ColName(0) & " like '*hn'")

Regards

 

[jimjojac]

:sign0060: great, it works. Tahnks and a nice day.