Hi Alexander, thanks for looking into this!
2006/5/8, Schroeder, Alexander <[EMAIL PROTECTED]>:
Hello Robert, a_recipient is dimensioned as VARCHAR(64) thus, it cannot be larger than 64 characters, so the condition will be useless.
My bad, I forgot to change the length of that parameter. It will be larger in real code.
Given additionally the fact, that at some places strings are padded with blanks (communication up to very recently), I really doubt you can measure any difference.
Well, the whole point of the condition was to prevent padding: if a long string is passed, it's truncated to 64 chars. If a short string is passed it's left unchanged (using SUBSTR here will pad). Again, sorry for the incorrect code. Kind regards robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
