Date: 05/20/05 (SQL Server)    Keywords: sql

Hello everyone,

I know that you cannot do the following if columnName is ntext datatype:

SELECT LEFT(columnName, 400)

Is there another way to achieve the same effect in the SQL query itself?

Source: http://www.livejournal.com/community/sqlserver/27272.html