[livium]

Hi!

I am wondering how can I get the first substring in SQL SERVER from a string using space as separator.

for example:
if I have this "word1 word2 word3", i want to get the first word which is "word1"
of course, i do not know the length of the first word, so i cannot use the substr function

Any ideas?

P.S.: i want to do this is a select query

Thanks!

This post has been edited by livium: 14 July 2011 - 12:32 AM

[e_i_pi]

SQL has CHARINDEX and SUBSTRING, so this should work:

SELECT
    CASE CHARINDEX(' ', MyTable.MyValue, 1)
    WHEN 0 THEN MyTable.MyValue
    ELSE SUBSTRING(MyTable.MyValue, 1, CHARINDEX(' ', MyTable.MyValue, 1) - 1)
    END
AS FirstWord
FROM MyTable

I haven't got SQL Server on this machine though, so I can't test it.

[livium]

It works!
Man, I thank you so much.
Have a nice day!

This post has been edited by livium: 14 July 2011 - 12:51 AM

[e_i_pi]

Gee a +1 would have been nice

[livium]

Sorry, I forgot!

[cgalhano]

Very good #4 e_i_pi nice job