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 Wanet Telecoms Ltd 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: *

  • Users: shutterace
  • Content: Threads
  • Order by date
  1. shutterace

    Showing distinct substring value in drop down

    I want to give the user a drop down that includes only the first 3 characters of a string. The string is format is ###-##-### and the field type is char. I have it working but I can't figure out how to only show distinct values in the drop down. Everthing I try gives an error. There are @ 30,000...
  2. shutterace

    How to select where a column contains a column!

    Hi, I can't figure this out. I am trying to select all records from a table(formatted) where one of its columns contains the value of a column in another table(paths). The data in the second table is a substring of the data in the first. Confused yet? Here is one example of what I am trying...

Part and Inventory Search

Back
Top