I want to get first 10 words in a column in sql query. (by using space)

any help is appreciated