like operator in Axapta

To get matching words in query

static void Job587(Args _args)
{
CustTable custTable;

select custTable where custTable.Name like("*john*");// match with john
select custTable where custTable.Name like("*john");// end with with john
select custTable where custTable.Name like("john*");// start with john
info(custTable.Name);

}