SQL Server Forums - charindex on ntext data type

Home | Weblogs | Forums | SQL Server Links

SQL Server Forums

Register Now and get your question answered!

All Forums

charindex on ntext data type

New Topic

Author

Topic

ducletan
Starting Member

Vietnam
25 Posts

Posted - 05/25/2012 : 03:02:32

help me code like charindex()
(CHARINDEX(): when i give a string(ntext) (DATALENGTH(ntext)/2) > 4000 then the charindex returns 0)

thank

Edited by - ducletan on 05/25/2012 03:05:09

visakh16
Very Important crosS Applying yaK Herder

India
48076 Posts

Posted - 05/25/2012 : 10:04:08

this is as per definition
see the link
http://msdn.microsoft.com/en-us/library/ms186323.aspx

it clearly suggests

expressionToFind

Is a character expression that contains the sequence to be found. expressionToFind is limited to 8000 characters.

Also see

http://www.bennadel.com/blog/966-SQL-CHARINDEX-Has-Data-Size-Limitations.htm

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Topic

New Topic

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.