I am considering the use of ADO instead of DAO because I want to connect to a SQL Server database but I have read a post (with no reply) of someone how could'nt use a "LIKE 'C*'" in a select statement..

Is it because it can't be done like that or it can't be done at all... or was the guy on the right track ?..

I am asking this because I don't want to change everything just to realize at the end that I can't use a LIKE statement...

thanx