Select from sql in condition that a certain column is start with a certain string.

Question

I am using sql. How to select all items from a table. where a column (varchar) path is start with a certain string : "stringABC"

select * from ATable where path like 'stringABC';

The above sql is wrong, can any one help me to fix it?

Many thanks!

Answer 1

select * from ATable where path like 'stringABC%'

Answer 2

select * from ATAble where path like 'string%'