Hi,
Sorry for  the  late reply been away on holiday.

The desired input would be  as follows

Company A       11111
Bob Green: My PC  doesnt boot the  error displayed is it has no system disk my PC booted fine yesterday.
But you came out and looked at it  last week. If my PC needs returning to your repair center can you 
configure me on another machine & setup my printer and RDP access please.

The text in bold can be mutiple lines but i would only like to show 2 lines or a number of charactors rather than the full string is there anyway i can pull just the required DB rows and then use the LEFT statement on that field and leave the rest as default.

Thanks  James