Separating data within a field (ie. Johnson,Emily)

[roisinmck]

I'm using foxpro/sql

I have a name field but unfortunatley is has both the first and last name within the same field. As noted above 'Johnson,Emily'

How do I parse out the name into different fields?

 

[mirtheil]

This should work (tested with PSQL v9.1):

select left(FieldName,locate(',',FieldName)-1),right(rtrim(FieldName),(length(f1) - locate(',',FieldName))) from TABLE

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com