SELECT POSITION(YOUR_TEXT, ' ') will find first occurrences so just put it in the loop....
Attachments
Library
Quick Reference
Archives
Sample Index
2005 Indexes