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!

Recent content by psoft123

  1. psoft123

    Concatenating Columns in Query Expression

    Can you give us some more examples? Here's what i used to get the concatenation from PS Query SELECT A.LAST_NAME || ' , ' || A.FIRST_NAME FROM PS_NAMES A WHERE A.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_NAMES A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.NAME_TYPE =...

Part and Inventory Search

Back
Top