Splitting name into first and last 1

[rjseals]

Hello,
This should be a pretty easy question but cant find the answer anywhere. I have a record of first and last names that I want to split into a first name and last name record. What would be the easiest query to use to split the two up?
Im not sure if it involves left(...) or what but any help would be appreciated.

Thanks

 

[swampBoogie]

Assuming that the first and lastname is separated with a space.

select substring(c from 1 for position(' ' in c) - 1) as firstName,
substring(c from position(' ' in c) + 1) as firstName
from t

If you have more complicated names, including possible middle names etc., there is no general solution.

There is no function named left in ANSI SQL.