how to format the name

[#1]

This might be a easy pick, but i am having hard time using string functions.

How can i make the name from Aaron, Jacobs to Aaron Jacobs all it needs to be done is get rid of the comma between last name and first name assuming the column name is Name(field)?

[shree909]

Hi ir ur are using in the script   Try this

Load

FirstName,

Lastname,

FirstName &'  '&Lastname AS  FullName

from ....

or  you can use the replace function

Replace(Name,',',' ')  As FullName

[sushil353]

try to use purgechar function:

purgechar(Name,',') as FullName

HTH

Sushil