Manupulating string in sql

[indraT]

Hi There,

I wanted to know if there is any way to manupulate this type of string in sql. I tried couple of function but its now giving me what i want. Pleae let me know if there is solution of this kind of problem.

In my database, [FirstName] is store as Joason P. or Mike H. or Jack ( Tom)

I need to extract this FirstName for first word before it hit the first space.
Like

Joason P. Like Joason
Mike H. LIke Mike
Jack (Tom) LIke Jack

If any one know about it Please let me know.

Thanks.

 

[hmckillop]

a select statement similiar to this might do it

select 
	case when charindex(' ', [firstname],1 )>0 then left(description, charindex(' ', [firstname],1 )) else [firstname] end
from MyTable

"I'm living so far beyond my income that we may almost be said to be living apart

 

[Pattycake245]

select left(FirstName, charindex(' ',FirstName)-1)

Tim

 

[indraT]

Thank you very much. Its working now.

Indr.