Hello All,

I am looking for some SQL function which would list all the tables in a DB starting with some specific names e.g

Database Name: DB_Employee
Table1 : tbl_for_employer
Table2: tbl_for_salaries_JUN_05
Table3: tbl_for_current_orders
Table4: tbl_for_salaries_JUL_05
Table5: tbl_for_salaries_AUG_05

From above DB i want some program to show me all the list of tables starting with 'tbl_for_salaries'.

All suggestions invited!


thanks,
Umer