Bill,

>It would also be much more efficient usage of disk space by storing the
>record buffers on disk with vowels trimmed out. But the assumption is that
>if someone put something in the database, they must have wanted it there.

I don't think I need to remind you how the VARCHAR column type works do I?

That's like in a compiler's string implementation saying that it has to
maintain a 2GB memory allocation because you never know, someone may want to
poke some meaningful bytes somewhere after the null termination character...

All bytes in the buffer for the VARCHAR column after the length indicator
are whitespace and no application should be making meaningful use of that
area without adjusting the length indicator to include it.

Oh no, we better watch out! Perhaps Bill has some sinister plan to hide
virulent byte sequences and transport them to people's machines via the
unused & unnoticed whitespace characters in varchar columns... <g>

You were begging for that one...

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

Developer's Search Site! http://developers.href.com