Problem searching strings

[Zoraya]

Hi everybody!
I have a table like this:
Create table t
(
id int
texto varchar(400)
)
And this table have around 1000000 rows. I want to be enable to make the next query in few seconds:

Select * From T
where
texto like %palabra%

Some idea how can I replace the like for something else. Something importan, I can't use full-index.

Thank you.

Zoraya

[MAK]

only fulltext index.


------------
Zoraya at 5/14/01 8:32:04 AM


Hi everybody!
I have a table like this:
Create table t
(
id int
texto varchar(400)
)
And this table have around 1000000 rows. I want to be enable to make the next query in few seconds:

Select * From T
where
texto like %palabra%

Some idea how can I replace the like for something else. Something importan, I can't use full-index.

Thank you.

Zoraya