Hi, I'm working with a database that has some sketchy data in it, i.e. the provinces are ON, Ontario, ONT, etc. I know that I could grab the 2 leftmost letters and search that way, but in other records they are not as distinct (i.e., Manitoba, MAN, MB).
Is there a decent way to create a recordset based on several spellings of a name? Either this is just too simple and I'm glazing over something, or it's the frontend software I'm using (Dreamweaver MX).
Excellent help thanks Scott! It took me a while to get the correct quotes etc because it constantly gave me errors, but your code was dead on. I'm more accustomed to using ASP and SQL/Access, so this PHP thing has me at a disadvantage. Dreamweaver is really bad at pinpointing errors too, so it took a little longer.