how to search for a table name in sql code example

Example: sql server find table name

select * from sys.tables where name like '%tablename%'