How to Use the Trim Function
Tutorials Shared by the Internet Community
|Top Tutorials||New Tutorials||Submit||Login||Register|
Total Hits: 13147
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...