Parse partial string 1

[Palmyra]

I think this is a dumb question, but I'm stuck.

I need to select part of the value in a field. I need to start at position 1 and only select to position 50.

My attempt, which is wrong:

SELECT left(fieldname,1,50) as newfield FROM table


Thanks.

 

[bborissov]

SELECT LEFT(fieldname,50)
FROM Table

or

SELECT SUBSTRING(fieldname,1,50)
FROM Table

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[Palmyra]

Thank you.