Main thing is how you want to use it. If you want it for balance transfers, get the longest period on offer at the 0% rate. If purchases, look for the same thing, or a decent mixture of both. Might get offers with low balance transfer fees, which usually means a shorter 0% interest period.
Main thing is always transfer to a different card before the end of the 0% interest term.