November 14, 2007 at 11:31 am
I have been looking for hours on how to perform a light search on an ntext field within a table. My client is using SQL Server Express and thus it does not support full-text indexing - which is a major limitation. Is there anything I can do to get similar results I would expect from a query like this? -
select topicid from topic where description like 'searchterm'
This does not work obviously as topic.description is of type ntext... I have tried to cast the description as type varchar or nvarchar and still have had no success... ie:
select topicid from topic where convert(nvarchar(4000),description) like 'searchterm'
Each time the query will run, but no results will be returned. Any help would be very much appreciated!!
- John
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy