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

    Group by with Concat

    Hi, Thanks for you reply, The Version on Pervasive is 9.1 The error message "[LNA][Pervasive][ODBC Engine Interface] Invalid parameter count for scalar function concat" I am not sure it likes the concat function in conjunction with the group by and I could not think of another way of doing...
  2. BillButton

    Group by with Concat

    Hi, I am new to this forum and hope I can get some good info. I am trying to write an sql statement that has a group by and concatinates a field as one string. I have been trying to use the following but with no success. I have tried many ways but none seam to work. select distinct...

Part and Inventory Search

Back
Top