A very different Comet was introduced in Supergirl #14 (October 1997).
Soon, it was learned that Comet's male form was originally Andrew Jones, a (male) jockey, who had been trampled by horses and "rebuilt" by an organization called "The Stable" as a superhuman with equine DNA.