Really? I thought the third argument specified how many characters to use.

SUBSTRING(fieldname,start_position, number of characters)

I'll look into this.