Get a Quote Today!   |   + 1 (301) 424 3903




 
  Community
 
Need Help?
Visit our Training page
Request a Quote or Consultation
SIGN UP FOR THE TERATECH NEWSLETTER
 

ColdCuts

Cut: concatenating multiple data fields in one cfgridcolumn
Cut#: 207 
Cut Date: 03/16/2001 
Cutter: mike leckie 
Topic: Appearance 
Overview: need to combine a five field street address into one so it can be displayed in one column of a datagrid. sql stmt is below. can it be done in the datagrid or does it have to be done in sql. not sure how to do it either way.

 

Cut Code:
SELECT LOC.LOC_NAME, LOC.LOC_GIN, RA.BUSINESS_PROCESS, RA.PROG_ID, ADDR.STREET_NUM, ADDR.PRE_DIR, ADDR.ST_NAME_TXT, ADDR.ST_TYP, ADDR.POST_DIR, ADDR.CITY_NAME, ADDR.ZIP_CD, ADDR.CNTY_CD ADDR, ADDR_TYP_TXT
      FROM MUMADM.LOC, MUMADM.LOC_RA_FEA , MUMADM.RA , MUMADM.LOC_ADDR , MUMADM.ADDR
      WHERE ( (LOC.LOC_GIN = LOC_RA_FEA.FK_LOC1_GIN) AND
      (LOC_RA_FEA.FK_RA1_ID = RA.RA_ID) AND
      (LOC.LOC_GIN = LOC_ADDR.FK_LOCLOC_GIN) AND
      (LOC_ADDR.FK_ADDRADDR_ID = ADDR.ADDR_ID) AND
      (LOC.LOC_NAME LIKE '%%') AND (RA.BUSINESS_PROCESS LIKE '%%') AND
       (ADDR.ADDR_TYP_TXT = 'PHYSICAL') )