I am using an Access adp which connects to a SQL server. I am trying to write a SQL string that will be the row source for a listbox on a form. I want to combine City State and Zip into one column. I've done this a million times using access data. I can't for the life of me figure out how to do this when SQL Server is involved. Any and all help is appreciated.
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Concantenating Columns in a SQL string
- Thread starter wild007
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
