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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.