need help with ntext search W/O full-text capability

  • 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