Re: Best way to force a varchar column to have no whitespace
Posted by Ed Murphy on 10/02/06 12:23
metaperl wrote:
> I have a column that I do not want any whitespace in whatsoever. I'm
> wondering how do enforce this a DDL level instead of in 40 million
> seat-of-the-pants after-the-fact computer programs accessing the
> database.
Use an update trigger to rewrite it with any whitespace stripped out.