Creating Initials from names

[ironic100]

I have a field in my screen called First Name and another field called Initials. I need to make it so that when I enter a first name, the initials field populates with the initals of however many first names there are.

For example, Tom Green Jones should come up as T G (assuming Jones is a last name). Similarly, Tom Williams Green Jones should be T W G.

I believe I need to create an SQL for loop of some sort

Please advise.

 

[sem]

SUBSTR(FirstName,1,1)

Regards, Dima

http://seminihin.narod.ru

 

[ironic100]

Thanks Dima, but this seems to work only for one name i.e. a single string without whitespace.

What I really need is a way to intialise ALL the names that are input into the 'first_name' field.

For example if I input my name as:

first_name: John Albert Downs
last_name: Smith

The 'initials' field should populate with 'J A D' with no reference to the last_name.

OK thanks alot