Fetching records from sql in listbox

See more:

SQL-Server-2005

C#2.0

C#3.0

C#

, +

Hi everybody,
Can anyone tell me that how i can fetch bulk records from sql server like a column containing 200,000 number of records in very few seconds as it is used as search result like in google. And please advice me that which statement i must use as query as i have to retrieve all records which contain the supplied string.


1)

Select * from table_name where addrs=*my_string%

2) Or i must create full text index for this.

Suggestion Required,
Akkywadhwa.