Using Like in x++ select statement

Use wildcard "*" in select statement
Visit the below link:
http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.axapta.programming&lang=en&cr=US