How to Use the Trim Function
|Top Tutorials||New Tutorials||Submit||Login||Register|
Total Hits: 12719
Total Votes: 144 votes
Category: Basic SQL/Basic SQL Misc
Submitted on: 2008-04-11 10:16:17
Submitted By: Shekhar
Description:When running more complex queries, such as concatenating strings, often times you may need to trim whitespace from the values.
Let’s look at an example of this. Remember the query we ran for concatenating:
SELECT CONCAT (productName, ” , ” , price) FROM products;
As it is the output would be XBOX , $399 More detail...