Hi All

This is probably very simple, but I just don't know the answer to it.

What I want to do is select 50 chars of a field and then put '...' at the
end of this selection, eg:

SELECT LEFT(DESC,50) + '...' FROM MyTable

The above doesn't work, but there must be some form of MySQL syntax that
lets me do this - right?

Thanks

Laphan

Laphan wrote:
The + operator is used for string concatenation in Microsoft SQL Server
and some other products.

In MySQL, the way to do what you want is:

SELECT CONCAT(LEFT(DESC,50), '...') FROM MyTable

See http://dev.mysql.com/doc/mysql/en/String_functions.html for more
information.

Regards,
Bill K.

Many thanks Bill

Much appreciated.

"Bill Karwin" <bill (AT) karwin (DOT) com> wrote

Laphan wrote:
The + operator is used for string concatenation in Microsoft SQL Server
and some other products.

In MySQL, the way to do what you want is:

SELECT CONCAT(LEFT(DESC,50), '...') FROM MyTable

See http://dev.mysql.com/doc/mysql/en/String_functions.html for more
information.

Regards,
Bill K.