How many times do you use the function LIKE? Probably more than you think. I use it quite often. Especially dealing with customer related information where I only have information on a piece(s) of the data.
Anyway, about a month or so ago (maybe longer), I was looking at the LIKE function in books online when I noticed that there where several different match patterns that you can utilize to find what your looking for. I must admit, I didn’t know that! Oh the joy’s of learning something new! Even as trivial as this!