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.
| Author |
Topic |
|
jimmy.hunt
Starting Member
21 Posts |
 Posted - 2006-04-11 : 12:12:30
|
| What is the largest Text Data Type I can use?Thanks!JamesJames Hunt |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-04-11 : 12:14:33
|
| TEXT------------------------I think, therefore I am - Rene Descartes |
 |
|
|
jimmy.hunt
Starting Member
21 Posts |
Posted - 2006-04-11 : 12:21:10
|
| The problem is I had a table that used ntext and I need to do some data manipulation. How can I manipulate this data? ntext data type does not allow functions to be run on it like replace or substring. How should I handle this? Convert the ntext to text?Thanks!JamesJames Hunt |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-04-11 : 12:33:29
|
| Look for UPDATETEXT in BOL. Also the max local variable you can have is VARCHAR(8000). Where as SQL2K5 has VARCHAR(MAX) which supports a larger data.------------------------I think, therefore I am - Rene Descartes |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-04-11 : 14:36:38
|
quote:
Originally posted by jimmy.hunt
The problem is I had a table that used ntext and I need to do some data manipulation. How can I manipulate this data? ntext data type does not allow functions to be run on it like replace or substring. How should I handle this? Convert the ntext to text?Thanks!JamesJames Hunt
You can use the SUBSTRING function with TEXT or NTEXT.CODO ERGO SUM |
|
|
|
|
|
|
Largest Text Data Type?