Re: SQL Humor

>> A VARCHAR(n) won't contain extraneous blanks unless the developer explicitly includes them in the value. <<

Not the developer, the data entry person who is probably an end user these days. The DB guy's job is to add a constaint like "CHECK (TRIM (BOTH foobar) = UPPER (foobar))" to the column on his side. Now how often have you seen Newbies go to that trouble?

Instead you see a lot of VARCHAR(50) -- notice the magic number fifty from ACCESS programmers -- columns which will eventually collect garbage, like 40 spaces and a period. Even worse, NVARCHAR(50) whcih collect garbage in Chinese! Received on Fri Aug 19 2005 - 16:37:55 CDT