> SELECT CONCAT( `vend_city` , ',', `vend_state` , ',', `vend_zip` )
>
> produces comma separated address
actually, there will be three commas in a row
;o)
CONCAT defaults to comma-separated
CONCAT_WS "with separator" lets you specify the character to use, and in my
example, the character was empty, i.e. no character --
concat_ws(''
, coalesce(col1,'')
, coalesce(col2,'')
, coalesce(col3,'')
)
> Rudy's coalesce option was not comma separated.
at that point, we were talking merely about concatenating, not
comma-separating
> So how does one pull addresses in printable form?
concat(
coalesce(col1,'')
, coalesce(col2,'')
, coalesce(col3,'')
)
rudy
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
