I need to populate a column in my database using data from another column using the first character of each word within the column
EXAMPLE:
"old_column"
105 south court street
77 office park road
*brentwood 2

"new_column"
1scs
7opr
*2

Would this be a substr issue?
Any help would be greatly appeciated
thanks,
scotta