Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Substring TEXT column

Author  Topic 

Brittney10
Posting Yak Master

154 Posts

Posted - 2013-03-11 : 11:25:26
How can I get the rightmost 4000 characters from a TEXT data type column. I assume this can be done using SUBSTRING, but am unable to do this in my attempts.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2013-03-11 : 11:43:10
SELECT RIGHT(CAST(textColumn AS varchar(max)), 4000) FROM myTable
Go to Top of Page
   

- Advertisement -