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)
 contains

Author  Topic 

rico_bano
Starting Member

35 Posts

Posted - 2007-07-16 : 15:54:17
i have a knowledgebase that i want people to do text searches using CONTAINS.

My problem is i need to format the input string into the correct format. i.e quotes around the string, replace spaces for ors etc etc.

Is there any good sites with examples of how to do this. I have a reasonably good idea but there seems to be alot to to consider regarding what the user is inputing in.
   

- Advertisement -