This is a fairly simple task.
Since the two Prod_Name values appear to be the same type, use the
UNION
[
^] clause.
select Prod_Name from tbl_Product_Master where Prod_Name like 'm%' order by Prod_Name asc<br />
UNION<br />
select Prod_Name from tbl_Product_Master where Prod_Name not like 'm%'<br />
Note that this will remove all duplicate values.