Select statement in SQL Server

Aug 1 2011 2:14 AM

Hi,

we create a table which has a columns named as name. From name column we want to select only first three name if name contains more than three character Left other character from name. How can do that ?