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 |
|
ilimax
Posting Yak Master
164 Posts |
 Posted - 2009-06-08 : 19:43:18
|
| I have field in the table set as Ntext datatype with default value '' - two apostrophy. How I can read this value in Where clause.I have error Ntext are incompitable in the equel opearatorI set Where Field = '' |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-06-08 : 20:45:58
|
do you need really text datatype ? text has some restriction and quote from http://msdn.microsoft.com/en-us/library/ms187993(SQL.90).aspxquote:
Important:ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead. For more information, see Using Large-Value Data Types.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
ilimax
Posting Yak Master
164 Posts |
Posted - 2009-06-08 : 20:53:25
|
| I can not change datatype in table ... I do not have rights. I have to just pull report. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-06-08 : 20:56:39
|
convert it to varchar and then compare
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Ntext value