substring - SQL Server Forums

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 2000 Forums

Transact-SQL (2000)

substring

Author

Topic

mikejohnson
Posting Yak Master

153 Posts

Posted - 2005-01-13 : 17:23:50

if you do a substring on a ntext field, can it return more than 8000 characters?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-01-13 : 17:38:53

no.


declare @t table (b text)
insert into @t (b)
select replicate('a', 9000)

select substring(b, 1, 9000)
from @t

Go with the flow & have fun! Else fight the flow

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources