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?