I suspect, from experimentation, that substr() is not binary safe, in that if some part of the field contains an all-bits-zero byte, it will "stop short".
What I wish to do is to pick out byte ranges of arbitrary length, at an arbitary offset into a BINARY(N) column. Perhaps LEFT() and RIGHT() might be my friends? I haven't been able to set up sufficient experiments yet. Can anyone confirm, or make further suggestions? Michael -- Michael Fischer Happiness is a config option. [EMAIL PROTECTED] Recompile and be happy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]