Hi,

I have a report in which I need to display only the last word of a string. (i.e. if the string is 'Calif Pro Am White', I have to display 'White' in place of the whole string) how should I replace the whole string with only the last word?

Thanks,
Gauri

Did it!
by using Right and Instr and length functions of string:

Right(String,Instr(String,"",length(String)))