Who's On?

	Membership:
	Latest: Jeffin Joy
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 4988

	People Online:
	Visitors: 47
	Members: 0
	Total: 47

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

join "City, State Zip"

3 Replies

0 Subscribed to this topic

24 Subscribed to this forum

Sort:

Author

Messages

DavidBrianCampbell

New Member

Posts: 0

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

New Poster

9/20/2007 1:58 PM

Brian,

Not sure if I follow. What are you trying to do?

DavidBrianCampbell

New Member

Posts: 0

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

New Poster

9/20/2007 2:15 PM

trim(e.city) || ', ' || trim(e.state) || ' ' || trim(e.zip) as city_st_zip