I have a table with a field "Information" in which i would like to get only the first character of all the words.
"Information" fields contains 5 rows
1. What is my name?
2. Ohio is a nice place.
3. Oh My God !!!
4. Job Well done..,
5. Hearty Welcome to our chairman.
I'd like to run a query which will pull only the first character of each word in each row.
Requesting your help please