Something like

select substring(name,1,charindex(' ',name)), substring(name,charindex(' ',name) + 1,len(name))

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples