I have taken on board the suggestions and run this one on the debugger:
search_table:

MOV R7,A
MOV B,#9
MUL AB
MOV DPH,B
MOV DPL,A
CLR A

'MOV DPTR,#table 'point DPTR @ table


loop:
MOVC A,@A+DPTR 'get a character
JZ exit 'jump if acc 0 to exit
LCALL WRITE_TEXT 'write it to the port
INC DPTR 'get next char
CLR A 'clear acc for next character
SJMP loop 'loop back to get a character

'exit of acc = 00

exit:
'pop back the value of the acc
MOV B,#00h 'and make B zero??
MOV A,R7

RET
I think I will have to clear up my code for the LCD as it still produces garbage but it must be comming from the Initialisation routine and timing??