Natura 2000 species table no code_2000

SELECT ltrim(str(id_eunis,10)) as id_eunis,
    code_2000,
	scientific_name,
	species_group_name
FROM EUNIS.v1.BISE_Species_Information
WHERE LEN(code_2000) = 0
ORDER BY scientific_name