Search file name pattern in table, with select query

[Former Member]

Hi All,

I have one table with data saved like in one column : row 1 =abc.txt, row 2 = def.txt. row 3 = xyz.txt.

And I have one variable with full file name var1 = 01_abc_2011.txt

Please guide how to make select query to select data from table. Or is there any standard function can be use for this type of search

Regards

[Former Member]

Hi All,

I have one table with data saved like in one column : row 1 =abc.txt, row 2 = def.txt. row 3 = xyz.txt.

And I have one variable with full file name var1 = 01_abc_2011.txt

Please guide how to make select query to select data from table. Or is there any standard function can be use for this type of search

Regards

[Former Member]

CP