SQL语句

SELECT * FROM tOrder WHERE 'P'+SubString(CONVERT (Varchar,DATEPART(yy, MCreateDate)*100+DATEPART(mm,MCreateDate)),3,4)+SubString(CONVERT(Varchar,10000+MOrderID),2,4) LIKE 'P0703%'