select isbn, substring(title,1,10) as 'Abbreviated title'
from dbo.book

select left(author,5)
from dbo.book