Select the first string

[ddtpmyra]

I wanted to select the first word before spaces.

ex.
Science 101


result:
Science

[Rabbit]

You can find the first space using CHARINDEX() and then use LEFT() to get those first characters.

[ddtpmyra]

can you give me the whole sample syntax using both?

[ddtpmyra]

I use the sytax below but it didn't pick subject names with one work only.

ex.
science 101
history
science 102
biology
physical education

result:
science
science
physical

what I wanted is to select all but take out the 2nd word after a space

result wanted:
science
history
science
biology
physical

SELECT subject, ltrim(Left(subject, CHARINDEX(' ', subject)))FROM dapdata

[Rabbit]

Append a space to the end of subject before using charindex.

[ddtpmyra]

sorry rabbit i cannot understand what to do, can you help by re-writing my sql statement? i would appreciate it! :)

[Rabbit]

Append/concatenate a space.
subject + ' '

[ddtpmyra]

it works! thanks Rabbit!

SELECT subject, ltrim(Left(subject, CHARINDEX(' ',subject + ' ' )))FROM dapdata