all-species-search-listing

SELECT ltrim(str(id_eunis,10)) as id_eunis,
    CASE WHEN code_2000 IS NULL OR LTRIM(RTRIM(code_2000)) = '' THEN '-' ELSE code_2000 END as code_2000,
	scientific_name,
	species_group_name
FROM EUNIS.latest.Species_Information
ORDER BY scientific_name