Text is deprecated in SQL 2005. Change it to varchar(max) and it works.

CREATE DATABASE CODE_SAMPLE4

GO

USE CODE_SAMPLE4

GO

CREATE TABLE CODE_SAMPLE4

(PK INT NOT NULL IDENTITY CONSTRAINT PRIMARYKEY PRIMARY KEY,

CHARCOL varCHAR(max),

INTCOL INT DEFAULT 1)

GO

DECLARE @INT INT

SET @INT=1

WHILE @INT<=100

BEGIN

INSERT INTO CODE_SAMPLE4 (CHARCOL) VALUES('TEST')

SELECT @INT=@INT+1

END

SET @INT=0

WHILE @INT<=100

BEGIN

INSERT INTO CODE_SAMPLE4 (CHARCOL,INTCOL) VALUES('TEST',@INT+1)

SELECT @INT=@INT+1

END

GO

CREATE FULLTEXT CATALOG TEST AS DEFAULT

GO

CREATE FULLTEXT INDEX ON CODE_SAMPLE4 (CHARCOL) KEY INDEX PRIMARYKEY

GO

--below query erroneously does not return any rows

SELECT * FROM CODE_SAMPLE4 AS CS4 JOIN

CONTAINSTABLE (CODE_SAMPLE4,CHARCOL,'TEST',100)

AS FT ON FT.[KEY]=CS4.PK

where intcol>10

ORDER BY RANK DESC

GO

CREATE VIEW CODE_SAMPLE4_VIEW WITH SCHEMABINDING

AS

SELECT PK, CHARCOL, INTCOL FROM DBO.CODE_SAMPLE4 WHERE INTCOL>10

GO

CREATE UNIQUE CLUSTERED INDEX CODE_SAMPLE4_VIEW_INDEX ON

CODE_SAMPLE4_VIEW(PK)

GO

CREATE FULLTEXT INDEX ON CODE_SAMPLE4_VIEW (CHARCOL) KEY INDEX

CODE_SAMPLE4_VIEW_INDEX

GO

--below query returns all rows

SELECT * FROM CODE_SAMPLE4_VIEW AS CS4 JOIN CONTAINSTABLE

(CODE_SAMPLE4_VIEW,CHARCOL,'TEST',100)

AS FT ON FT.[KEY]=CS4.PK

where intcol>10

ORDER BY RANK DESC

GO

SELECT * FROM CODE_SAMPLE4_VIEW WHERE CONTAINS(*,'TEST')

GO