SQLTeam.com | Weblogs | Forums

CONTAINSTABLE does not respond


#1

Hi,

When trying to search for a text like "1.2.3.4" using the CONTAINSTABLE function, there seems to be no response and it keeps on loading and sql memory gets full.

The query I have used is

select * from CONTAINSTABLE(document_text, [text], '"1.2.3.4*"')