De Zeemeerman (1996)
De Zeemeerman is a 1996 Dutch comedy film directed by Frank Herrebout. The movie revolves around a young man who has a hard time getting girls because he permanently smells of fish. The cure, offered by a mad professor, turns him into a male mermaid, or mer-man ('zeemeerman' in Dutch).
More at Wikipedia.