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 |
|
jpradeep
Starting Member
8 Posts |
 Posted - 2006-10-09 : 11:45:55
|
| Hi AllI have memo field in sql server 2000 and tried to alter it to varchar(250) but it is showing error while execute query on query analyser. If i did it from enterprise manager it is ok. How can I alter memo field to varchar(250) using query.ThanksPradeep |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-09 : 12:09:41
|
| Memo field? in SQL server?What's that?Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
jpradeep
Starting Member
8 Posts |
Posted - 2006-10-09 : 12:29:24
|
| HiSorry.it was ntext field to varchar. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-10 : 00:54:30
|
| You can use CONVERT function to do the conversion from ntext to varchar...but beware, if your data contains unicode characters, you may get strange results. You could use nvarchar to avoid this.Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
|
|
|
Alter memo to varchar error msg