• Search Forums
    Advanced Search Topics Posts
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
New Member Send Private Message
Posts: 0
New 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 Send Private Message
Posts: 277
Veteran Member
9/20/2007 1:58 PM
Brian,

Not sure if I follow. What are you trying to do?
DavidBrianCampbell
New Member Send Private Message
Posts: 0
New 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 Send Private Message
Posts: 277
Veteran Member
9/20/2007 2:15 PM
trim(e.city) || ', ' || trim(e.state) || ' ' || trim(e.zip) as city_st_zip