I want to SELECT a number of rows in a SQL database using both
DISTINCT
LEFT
SELECT DISTINCT(alltext) LEFT(alltext, 100)
FROM programoversigter3
WHERE alltext LIKE '%kommunisme%'
DISTINCT
is a keyword not a function and you need to use ,
after each column. So, your query should be
SELECT DISTINCT alltext, LEFT(alltext, 100)
FROM programoversigter3
WHERE alltext LIKE '%kommunisme%'