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-20 : 10:08:57
|
| I have values in a ntext that I need to move to a varchar(8000).There are some records that are over 8000 characters, but I'm will to do a where datalength(columnname) < 8000 and lose a few records that are longer. Can someone help me find a way to move some ntext values to a varchar(8000) column?Thanks!James Hunt |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-04-20 : 10:27:45
|
| Did u try using Convert(varchar(8000, nTextField)and / or Ltrim functionSrinika |
 |
|
|
|
|
|
Values in a ntext that I need to move to a varchar