Re: [SQL] Variable-length Types

[DalTech - CTE]

> It takes a string and returns something that looks like Varchar(22);
> If someone types in 10 digits, it returns output like (###) ###-####
> If a user enters 7 digits, it picks a default area code and returns
> (415) ###-####,
> and if they type more than 10 digits or enter any digits after an "x",
> they get (###) ###-#### x###


Why not treat each group of ###s as its own variable? You would then have a
lot of freedom to insert defaults if null and the like.

-C. Currie