Looking For A Space

Okay, so i've been working in foxpro for a while, but now we're moving on to bigger stronger faster. my question is, in foxpro, i used to be able to fix some name formatting issues with two commands:


replace all fname with subs(name,1,at(' ',name))
replace all lname with subs(name,(at(' ',name)+1),(30-at(' ',name)))


this basically locates the space in the name on each record, and replaces the first name with 0-space and the last with space-end of field

little cude, but it gets the job done. so basically i'm looking for the same solution but for t-sql, i tried something like:

update t1
set name=substring(name,1,at(' ',name))
from temp t1


with no luck, AT() is not an expression in sql, so what is out there that's like it?