Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ntext

Status
Not open for further replies.
mad01

mad01

Programmer
Jul 30, 2000
23
AE
In SQL 2000 I'm using ntext datatype cause it holds more data than nvarchar but I'm facing some problems with it, I'd like to know if the data in ntext datatype is searchable or not?!
thanks :)
 
Sort by date Sort by votes
you can search with like. I would have a look at the full text indexing features of SQL 2000, if you are going to do a lot of searching on these fields
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

1DMF
  • Locked
  • Question
SELECT UNION - nText Field? 2
Replies
7
Views
232
1DMF
1DMF
GRHE
  • Locked
  • Question
ntext - Save to File
Replies
1
Views
77
GRHE
GRHE
Ascalonian
  • Locked
  • Question
NText issue 1
Replies
4
Views
166
Ascalonian
Ascalonian
mwheads
  • Locked
  • Question
Exporting an ntext field to excel
Replies
1
Views
113
markros
markros
kav123
  • Locked
  • Question
Updating an 'ntext' field
Replies
12
Views
396
kav123
kav123

Part and Inventory Search

Sponsor

Back
Top