how to show only a part of a field

[giovamc]

Hi, i have a field that is varchar(50), but i only want to show the first 20 characters, i want to show that in a graphic in axis x. How can I do this, do I have to do this in the statement I'm using to build this graphic?

 

[lewisp]

Use substr(text,1,20);