Showing results for 
Show  only  | Search instead for 
Did you mean: 

Escalate Topic

String capitalisation

Changemaker II

Hi all,

I wonder if anyone has a simple solution for the following. I've found what I think are parts of the answer, but nothing that leads me to a full implementation.

I have some text being returned from a db lookup and it's all in capitals. I want to convert that part of the text into mixed case, each word should start with a capital letter.

I can find suggestions on using an SQL function to achieve this, but also that it should be easier in the product to which the information is returned, which in this case is the Firmstep platform. The text processing calculations I've found don't seem to have anything that translates directly into what I'm after. If anyone has a pointer that would help me out, I would be most grateful.