no differencedeclare @table table(field varchar(10))insert @table values ('klhjk'),('mkghjhj'),('m rf'),('kjh'),('ewqf'),('m7656')select *from @tablewhere field like ('m%')select *from @tablewhere field like 'm%'field-----------mkghjhjm rfm7656field-----------mkghjhjm rfm7656
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs