you can use a combination of wilcards, example:
SELECT MYFIELD FROM MY TABLE
WHERE MYFIELD LIKE ‘M%’ OR MYFIELD LIKE ‘MA%’ OR MYFIELD LIKE ‘MAR%’</pre>
This will return everything that starts with M, MA and MAR but also will eb included MS*, MR* and so on.
If instead you want ONLY MAR* just <b>MYFIELD LIKE ‘MAR%’ </b>.
I hope this helps.
Searching a column for M% OR MAR% will give you the same results as searching for M% (and will place additional load on the SQL Server). Are you trying to figure out how to use an input parameter?
Can you post to us your T/SQL code that you have already and we’ll see what we can do with it?