select LEFT(names, 1) from table
Tim Johnson wrote:
Hello:
Is it possible to use mysql to select only
the first letter of a string in a column?
IOWS "select names from table" -> "select <first letter of> names from table"
another way of asking my questions would be,
Is it possible to truncate columns in selection
set to a specific length (in the case: 1)
Pointers to relevant documents are welcome.
Thanks
tim
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]