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!
-
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!
Recent content by shutterace
-
Showing distinct substring value in drop down
Um. Nevermind I figured it out. :~/ qPCL = "SELECT DISTINCT SUBSTRING([Parcel_Number], 1, 3) AS parcel FROM AZLiens GROUP BY SUBSTRING([Parcel_Number], 1, 3) ORDER BY SUBSTRING([Parcel_Number], 1, 3)"- shutterace
- Post #2
- Forum: Microsoft SQL Server: Programming
-
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...- shutterace
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
How to select where a column contains a column!
Terry, That worked! Thanks! -Jim- shutterace
- Post #4
- Forum: Microsoft SQL Server: Programming
-
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...- shutterace
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
