Regular expression and performance benefits

Regular expression can be effectively used to get performance benefit in certain cases. Consider the following customers table where custid is the primary key.