You use the '%' as the wilcard character.

If you want to search for a string starting with 'ABC' then you would use:
Select * from Customers where LName like 'ABC%'

If you want to search for a string ending with 'ABC' then you would use:
Select * from Customers where LName like '%ABC'

If you want to search for a string containing 'ABC' then you would use:
Select * from Customers where LName like '%ABC%'

P.S. 'Name' is a reserved word and you should consider changing the name of that field to something else in your database.

HTH,
Greg