RocketScientist's Miscellaneous Ramblings
posts - 76, comments - 354, trackbacks - 3

October 2005 Blog Posts

Substring Searching

I need a away to effectively search substrings. The situation: I have a claim number field (consider it to be a random alphanumeric string). My user base was trained that since the claim number field could take wildcards, it's best to put them both before and after your search term, which effectively prevents any use of SQL Server indexes. The trainer needs to be introduced to the ballbat of doom. Now we can't fix the functionality to not allow the extra wildcards because that'd mean changing all of our trained user habits, and in addition our "project manager"...

posted @ Tuesday, October 04, 2005 1:32 PM | Feedback (2) |

Powered by:
Powered By Subtext Powered By ASP.NET