Zero Effect (1998)
Zero Effect is a 1998 mystery film written and directed by Jake Kasdan (son of writer/director Lawrence Kasdan). It stars Bill Pullman as "the world's most private detective" Daryl Zero and Ben Stiller as his assistant Steve Arlo. The plot of the film is loosely based on the Arthur Conan Doyle short story "A Scandal in Bohemia".
More at Wikipedia.