Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Search options on shared SQL server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-04 : 19:46:17
Howard writes "Our dedicated NT 4.0 server came with space on a shared SQL server 7.0 machine. I want to implement a search function but since the machine is shared, I'm unable to create a Full-Text catalog. I would like to be able to search part of field: searching for 'saw' should bring up 'tablesaws'. As far as I know, the only time you can use CONTAINS is in a full-text search. What are my options with out using a full-text catalog?

Thank you very much,

Howard"
   

- Advertisement -