please help!

[iwui]

If we have a table with a column name 'customer' which contains first name & last name separated by a space, how can we display it in 2 columns: first name & last name?

[John]

Well, you can split it at the space with a SQL command. You'll have to effectively do a "left" of the string up to the space, and a "mid" of the string following the space.

You don't mention which type of db engine you're using. Consult your database manual to find the syntax. Of course the right solution is to make separate fields (even by running a query / stored proc that splits them) and then combining when desired with magiccell.

Thanks,
John


------------
iwui at 1/24/2002 4:15:27 PM


If we have a table with a column name 'customer' which contains first name & last name separated by a space, how can we display it in 2 columns: first name & last name?