https://community.sap.com/t5/application-development-and-automation-discussions/search-file-name-pattern-in-table-with-select-query/m-p/7609890#M1569206 <HTML><HEAD></HEAD><BODY><P>CP</P></BODY></HTML> Wed, 19 Jan 2011 23:56:18 GMT Former Member 2011-01-19T23:56:18Z https://community.sap.com/t5/application-development-and-automation-discussions/search-file-name-pattern-in-table-with-select-query/m-p/7609889#M1569205 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have one table with data saved like in one column : row 1 =<STRONG>abc</STRONG>.txt, row 2 = <STRONG>def</STRONG>.txt. row 3 = <STRONG>xyz</STRONG>.txt.</P><P></P><P>And I have one variable with full file name var1 = 01_abc_2011.txt</P><P></P><P>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</P><P></P><P>Regards</P></BODY></HTML> Wed, 19 Jan 2011 23:22:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/search-file-name-pattern-in-table-with-select-query/m-p/7609889#M1569205 Former Member 2011-01-19T23:22:51Z https://community.sap.com/t5/application-development-and-automation-discussions/search-file-name-pattern-in-table-with-select-query/m-p/7609890#M1569206 <HTML><HEAD></HEAD><BODY><P>CP</P></BODY></HTML> Wed, 19 Jan 2011 23:56:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/search-file-name-pattern-in-table-with-select-query/m-p/7609890#M1569206 Former Member 2011-01-19T23:56:18Z