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?