To extract the first word from a text box

[Caro]

I need to extract the first word from data in a text box (up to the first space) to use in an sql statement. What is the best way to do this?