select statement to show tables

Question

Does anyone know the syntax for a script that will bring back all the tables in a database that begin with "CAPA" and "CAPD"?

Answer 1

Select TABLE_NAME from INFORMATION_SCHEMA.TABLES
Where Left(TABLE_NAME,4) = 'CAPA' or Left(TABLE_NAME,4) = 'CAPD'

Answer 2

That's great thanks