I am trying to use the wildcard character(%) to query on a text field in a large SQL Server 6.5 table and am experiencing very poor performance. Are there any special indexes or techniques I can use to increase performance in this type of query? Any help would be greatly appreciated.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.