Re: Oracle/JDBC driver concatenation problem - help!

Joe Pusateri wrote:
>
> Dan,
>
> I seem to remember running across this before. Us the AS keyword to
> give the concatenated "column"
> a name:
> SELECT
> C.VALIDATION_TYPE || ' ' || C.PROVISION_MODE || '-' ||
> C.STYLE_SEQUENCE 'SERVICE_STYLE' AS NewCol
> FROM
> SERVICE A, SERVICE_CATEGORY B, SERVICE_STYLE C
> WHERE
> A.SERVICE_CATEGORY_ID = B.SERVICE_CATEGORY_ID AND
> A.SERVICE_STYLE_ID = C.SERVICE_STYLE_ID
>
> Joe Pusateri Senior Consultant, Zeal, Inc
> joep@zealinc.com http://www.zealinc.com/
> -------- "Your Technology Partner" Northbrook, Illinois --------
> - Client/Server/Internet: SilverStream, Java, VB, CGI/HTML, -

Joe,

Thanks. It works either with AS or without, as long as I don't have the single quotes. Not sure why MS Query bothers to put those in my SQL. Live and learn.

Dan

--
Daniel Kirkdorffer
Sr. Consultant, Syllogistics, LLC.
Email: dan.kirkdorffer 'at' syllogistics 'dot' com
       daniel.kirkdorffer 'at' attws 'dot' com
Web:   http://www.syllogistics.com/
       http://members.aol.com/dankirkd/
Visual Cafe Tips:
       http://members.aol.com/dankirkd/vcafe.htm