Reply to Re: Removing white spaces in a varchar column
Posted by --CELKO-- on 09/17/05 05:02
>> table . It has a nullable column called AccountNumber, which is of VARCHAR(n) type. <<
That is a very bad code design because it prevents check digits and
makes validation rules more complex. If you had validation rules in the
DDL, you would not have this problem. First mop the floor, then fix
the leak.