sql query select by half a names from database code example

Example 1: how to list all values of a column that start with a letter in sql

SELECT Name FROM Sample.MyTest WHERE Name %STARTSWITH 'M'

Example 2: how to list all values of a column that start with a letter in sql

SELECT Name FROM Sample.MyTest WHERE NOT Name %STARTSWITH 'M'