select concat(left(NameOfTextField,locate(' ',NameOfTextField,$CharactersToDisplay)-1),'...') from TheTable where TheID = $TheID