sql starts with and ends with

SELECT from Mytable where field x contains string X or field. Ends with in sql query. Beginning Sql …