Subject Substring and negative numbers
Author Jeremy Poppleton
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]