column length reducing

The length of a column is 20(varchar),
When i m trying to execute select column name it gives all 20 characters.
My requirement is - is there any option by which i will be able to see only 10 characters ?select left(10,columnname)|||umm...think you go t it backwards...|||nope it's an anagram|||Originally posted by Karolyn
nope it's an anagram

Is anagram an alias for incorrect syntax:D

USE Northwind
GO

--SELECT LEFT(10,LastName) FROM Employees

SELECT LEFT(LastName,10) FROM Employees
GO|||My Bad !!!

Can blame it on another long day perhaps