Difference between revisions of "SQL String operators"

Revision as of 12:45, 18 January 2013

String operators

<expression1> operator <expression2>[ operator <expression3>…]

Operators used with Character expressions:

Operator	Operation
\|\|	Concatenate the <expression2> to the end of the <expression1> string
+	Concatenate the <expression2> to the end of the <expression1> string
-	The <expression1> string is trimmed of trailing spaces, the <expression2> string is concatenated to the end of the <expression1> string and the previously trimmed spaces concatenated to the end of the <expression2> string

SELECT trim(title) || ’ ’ || last_name as "Full Name";
FROM customers;
ORDER BY last_name

@@ Line 11: / Line 11: @@
 Operators used with Character expressions:
-{| class="wikitable"
+{| class="wikitable" idth=100%
 !Operator||Operation
 |-
-|<nowiki>||</nowiki>||Concatenate the <expression2> to the end of the <expression1> string
+|valign="top"|<nowiki>||</nowiki>||Concatenate the <expression2> to the end of the <expression1> string
 |-
-|<nowiki>+</nowiki>||Concatenate the <expression2> to the end of the <expression1> string
+|vaign="top"|<nowiki>+</nowiki>||Concatenate the <expression2> to the end of the <expression1> string
 |-
-|<nowiki>-</nowiki>||The <expression1> string is trimmed of trailing spaces, the <expression2> string is concatenated to the end of the <expression1> string and the previously trimmed spaces concatenated to the end of the <expression2> string
+|valign="top"|<nowiki>-</nowiki>||The <expression1> string is trimmed of trailing spaces, the <expression2> string is concatenated to the end of the <expression1> string and the previously trimmed spaces concatenated to the end of the <expression2> string
 |-
 |}