Post reply

Timout exception, using like operator on text datatype column in SQL2005

  • December 11, 2008 at 11:22 pm

    #72266

    Hi,

    I have a requirement to search a text on the text datatype column and if the value exist, then return the row.

    DataBase: SQL 2005.

    For this, I have written a SQL select statement like;

    Select Column1, Column2, Column3 from table where text_datatype_column like '%abchelp%'.

    The above query execution raises performance issue.

    Is there any other way to do text search on textdatatype column rather than LIKE operator ?

    Can anyone help me!

    Thanks in advance,

    Prakash Shanmugam

  • December 12, 2008 at 9:06 am

    #911693

    Is full-text search an option?

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • December 14, 2008 at 8:52 pm

    #912290

    Sorry I have missed the query part and now its updated in the post.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply