This simple query:





SELECT left(c.addr_5, CHAR_LENGTH(c.addr_5)-3) as trimmed


FROM vecusts c





Produces this error











Pressing OK I then get correct values in the trimmed column.


Can anyone assist or tell me what I am doing wrong?





Many thanks












[Non-text portions of this message have been removed]