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]


Reply via email to