Home » SQL & PL/SQL » SQL & PL/SQL » Join two fields
Join two fields [message #198277] Mon, 16 October 2006 06:42 Go to next message
Messages: 42
Registered: October 2006
How can i join two fields (strings) into one in an sql query?

Eg: select field A + field B as field from table;

Re: Join two fields [message #198281 is a reply to message #198277] Mon, 16 October 2006 06:44 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
Concatenate using either double pipe: <field_a>||<field_b> or concat(<field_a>, <field_b>)

The former is the most used.
Previous Topic: escape clause
Next Topic: Confusion in SQL Query
Goto Forum:

Current Time: Sat Jul 22 07:49:28 CDT 2017

Total time taken to generate the page: 0.10075 seconds