Using SQL Server 2005, how do I split a string so I can access first sub string?

For example, take the string "This is a Cat". How can I split the string by a space and access the item at index 1 which should return "This"?
May be we can split in an array ?
I am thinking in C# mode