I have the following sql statement in my MS Studio 2008 C# project that is connected to a sql server database:
cmd.CommandText = "SELECT DISTINCT * FROM MORTGEE WHERE MORTGEE_NAME = (@MN) ORDER BY MORTGEE_NAME ";
I would like to change this to a "LIKE" statement, I.E. LIKE (@MN).
I can't figure out the code, any ideas?