I have a list of IDs for a table in CSV forma...

[Steven_Aung]

I have a list of IDs for a table in CSV format.

What would be the most efficient way to retrieve a ref list?

Using SELECT with FIND function to match the table ID and the CSV text is very slow.

Is there a way to simply covert the CSV to a ref ID list without using SELECT?

[tony1]

@Steven_Aung If it’s a virtual column, try changing the type of the column to be a list of table refs.