getting the first letter of each word

[Jess Rubio]

I am having problem regarding on how would i create a store procedure that can return only the first letter of each word on a data.

ex. Community Service
the return data must be CS.
how would i create a simple sql statement for this query.

[Rabbit]

There is no simple statement for it. You would have to loop through the entire string looking for spaces and getting the first letter you come across after a space. You would then append it to a result string and return that. Also, you would use a function, not a stored procedure.