SQL Server Performance

Best way to search

Discussion in 'SQL Server 2005 General Developer Questions' started by rushonerok, Jul 11, 2006.

  1. rushonerok New Member

    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
  2. chopeen Member

    Why do you want to use SOUNDEX function?
    What kind of data does your database store?
    What kind of application are you developing?
  3. Madhivanan Moderator

    Can you post some sample data and the result you want?

    Madhivanan

    Failing to plan is Planning to fail

Share This Page