SELECT
CONCAT
(
LEFT
(
NameOfTextField,
LOCATE
(
' '
,NameOfTextField,$CharactersToDisplay
)
-1
)
,
'...'
)
FROM
TheTable
WHERE
TheID = $TheID