Can a digital cable have different connectors?

I purchased a Chord MScalar to use with my current and future DACs. Unfortunately, the MScalar only has optical and BNC outputs. While this is fine because my current DAC has a BNC input, many other DACs I’m interested in does not.  Seems like SPDIF cables can have different terminations like RCA or BNC.

Can a digital cable work with one end terminated with BNC and the other end another type of connector?