34,333
edits
Changes
→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.