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
renafi
Messages: 42
Registered: October 2006
Member
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
Frank
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: Sun Dec 04 10:54:38 CST 2016

Total time taken to generate the page: 0.04297 seconds