Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mpspillers

    Subquerying inside a LIKE statement?

    Works beautifully, thanks for all the help!
  2. mpspillers

    Subquerying inside a LIKE statement?

    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?
  3. mpspillers

    Subquerying inside a LIKE 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...
  4. mpspillers

    Subquerying inside a LIKE statement?

    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...
  5. mpspillers

    Subquerying inside a LIKE statement?

    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
  6. mpspillers

    Subquerying inside a LIKE statement?

    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
  7. mpspillers

    Subquerying inside a LIKE statement?

    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...
  8. mpspillers

    concatenate fields for a combo box?

    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...

Part and Inventory Search

Back
Top