yes, indeed there are all kinds of names.

Thanks a lot.

Hi guys,

Thanks a lot for your prompt replay and trying to really help me.

select actorname,

substring(actorname, 1, (C-1))

as lastname,

substring (actorname,(C+1),L)

as firstname

from A

select actorname,

substring(actorname, 1, (S-1))

as firstname,

substring (actorname,(S+1),L)

as lastname

from...

Hi ALL,

THANKS A LOT!

Thank you very much.