substring Query

[charvi]

Hi
i have problem in query to extract a sub string from a string
that is i want to extract first name from name
for eg if i have a name John Smith
i want to extract John how to extract this can any one suggest me query
thanks in regards

[FishVal]

[code=sql]
SELECT Split([FullName], " ")(0) AS FirstName FROM .....;
[/code]

Regards.
Fish