Evelyn,
That type of syntax is fine, even for versions of VFP before VFP7. Make sure that all the field names are spelled right. Test it in command window until you get the query you want.
Also, you'll want to use the INTO CURSOR clause of the SELECT command, so a browse window doesn't pop up when you run the form.
>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?
Steve Gibson