Trimming a Field to be certain amount of characters

[luvtitans50]

I have a field in my report called jobtitle, I only want it to display 35 characters? How can I achieve this?

Thanks,

 

[bborissov]

SELECT LEFT(JobTitle, 35) AS  JobTitle
....

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[NiceArms]

or if it's not the first 35 Characters you require:

SELECT RIGHT(JobTitle, 35) AS JobTitle
SELECT SUBSTRING(JobTitle,3,35) AS JobTitle

try each see the differing results

/Nice