Title Case??

[Rozza]

Hi,

Is it possible to change text from Upper case to Title case? I can see how you can change from lower to upper and upper to lower, but I can't find a function which will allow me to change to title case. There is more than one word in the text that I want to change. I also want to be able to perform this within a query.

Any help would be greatly appreciated.

Cheers

Paul

 

[DonQuichote]

Look in the help file for the

StrConv

function.

Best regards

 

[Rozza]

Thanks alot, it worked a treat!!