Searching my Sql Database

<i><b>Originally posted by : Mike (frankr6805@aol.com)</b></i><br />I want to put together a serach for my database but I am having trouble. I know the LIKE commmand but is there some other way to make the search 'smarter' and more comprehensive, would a stored procedure in teh sql server and sql syntax do a better job? does anybody know of any examples like this? your help is appreciated.<br /><br />thanks,<br />mike

<i><b>Originally posted by : </b></i><br /><br /><br /><br />------------<br />Mike at 7/4/2001 2:16:11 PM<br /><br />I want to put together a serach for my database but I am having trouble. I know the LIKE commmand but is there some other way to make the search 'smarter' and more comprehensive, would a stored procedure in teh sql server and sql syntax do a better job? does anybody know of any examples like this? your help is appreciated.<br /><br />thanks,<br />mike