![]() ![]() But what is the name of this new calculated column? Well, the truth is, it has no name it is simply a value. The SELECT statement used to concatenate the address field works well, as seen in the previous output. The trim() Functions In addition to RTrim() (which, as just seen, trims the right side of a string), MySQL supports the use of LTrim() (which trims the left side of a string), and trim() (which trims both the right and left). By using RTrim(), the individual columns are all trimmed properly. The RTrim() function trims all spaces from the right of a value. This can be done using the MySQL RTrim() function, as follows: SELECT Concat(RTrim(vend_name), ' (', RTrim(vend_country), ')') ![]()
0 Comments
Leave a Reply. |