Hello,

I would like to allow the search on a certain field to be performed excluding spaces and non-alpha-numeric characters. In other words, a search on IBM, I.B.M., I B M or I-B-M would all match to any of the others. In VFP I'd just index and search with CHRTRAN(). What's the best way to go about this in SQL Server?