Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

join "City, State Zip"

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
DavidBrianCampbell
Basic Member
Posts: 13
Basic Member
9/20/2007 1:39 PM
    I've used Chris' method to join First M. Last Names together (trim(last_name) || ', ' || trim(first_name) || ' ' || case when trim(middle_init) is null then trim(middle_init) else trim(middle_init) || '.' end) and was wondering if the same would work to join "City, State Zip" and keep the single spaces in. Thanks!
    Chris Martin
    Veteran Member
    Posts: 277
    Veteran Member
    9/20/2007 1:58 PM
      Brian,

      Not sure if I follow. What are you trying to do?
      DavidBrianCampbell
      Basic Member
      Posts: 13
      Basic Member
      9/20/2007 2:03 PM
        I have three fields City State and Zip I just want to put a comma after City and one single space between that and State and one single space betwwen that and zip and always keep it looking like:

        Chicago, IL 60609
        High Point, NC 27263
        Eureka CA, 90344

        Thanks!
        Chris Martin
        Veteran Member
        Posts: 277
        Veteran Member
        9/20/2007 2:15 PM
          trim(e.city) || ', ' || trim(e.state) || ' ' || trim(e.zip) as city_st_zip