Changes

MySQL Calculations and Concatenations

54 bytes added, 19:26, 22 October 2007
Trimming Whitespace from Text
</pre>
== Trimming Trailing Whitespace from Text ==
MySQL also provide a technique for remove any trailing whitespace from a text field. Say for example a data input operatior pressed the space bar for a few seconds after entering a company name into our supplier database. When this is retrieved the spaces will also be retrieved:
+-----------------------------------------------------------------------------+
</pre>
 
== Trimming Leading Whitespace from Text ==
The ''LTrim()'' function may be used in the same way to remove leading spaces from the left hand side of a text value.