Search results for query: *

Works beautifully, thanks for all the help!

Ahh, that had EVERYTHING to do with it. I checked my Titles table and almost EVERY record contained a trailing space! The case sensitive thing is still a bit of a problem, and harder to fix in the 67793 Person records. Is there a way to enforce "case insensitivity" in my SELECT statement?

Because it's a smallish list of 22 titles that the users are very familiar with. When they scan thru the results, they can see that the Person Roles contain variations of the titles they are looking for. They would probably consider it redundant and/or confusing if I included another column...

Yes, your first option was one of my original attempts: SELECT tblPerson.LastName, tblPerson.FirstName, tblPerson.Role FROM tblPerson, tblTitles WHERE tblPerson.Role Like '%' + tblTitles.title + '%' GROUP BY tblPerson.LastName, tblPerson.FirstName, tblPerson.Role; It does not error, but it...

Hmm, so does that mean I won't be able to use it? (I'm building a .Net webpage to query our SQL 2000 server...) Michael

Thanks for your quick reply! That definitely starts me on the right track. However I'm new to the "double pipe" thing. || When I used this in my query, SQL told me: Incorrect syntax near '|'. ? Appreciate it... Michael

Hi! I'm making the big switch from MS Access to SQL, and I'm having a hard time translating one of my old Access queries to SQL syntax. I have 2 tables, [tblPerson] and [tblTitles]. I want to see every record in [tblPerson] where the [tblPerson].[role] field CONTAINS (is LIKE) any of the...

Hi, folks - I'm building a database that tracks visitors to a clinic. Three of the fields in the [clients] table are: [client1stname] [clientlastname] [clientphone] In one of my forms I want the user to be able to pull down a combo box that concatenates these three items to use as the...