Best way to search | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Best way to search

I have sql 2005 express. I just want to do some simple searches on a few fields in a table. I think using % wildcard characters around everything might be pretty hard on the server right? Can anyone give me some articles I can read on the best way do perform searches. Should I use soundex? I’m not really sure what is the best way. Thanks. -Rush
Why do you want to use SOUNDEX function?
What kind of data does your database store?
What kind of application are you developing?
Can you post some sample data and the result you want? Madhivanan Failing to plan is Planning to fail