>hi jojo, thanks for your reply. but i'm having an error at Sele alltrim(lname)+", "+alltrim(fname)+" "+alltrim(mi)+"." as custname from bls. seems like sql does not accept the " " and "."

>>any more help?

If your using VFP 7 or higher, there should be no error.. double check also your quotation.