>>If that is using standard SQL Server syntax, then you should be using something like..
>>
>>cSQL = "select * from VRP_CONTACT where [CONTACT CONTACTID] = '" + crsrs.contact_opportunity_contactid + """
>>
>>Brackets around identifiers are SQL Server's way of handling illegal names.
>
>
>Thanks, got it.
>
>I suppose the fact that I haven't been coding in a while, and SQL Server was never actually in my skill set leads to all sorts of new problems for me!
You're in for quite a ride... specially when everything looks fine for quite a while, and then you stumble upon something you thought trivial... for example, val("423blabla")=423 in xBase languages since forever. SQL server will bang trying to cast() that as an integer. Or... but you already know that VFP has better string cutlery than M$ Office and SQL server taken together. I've caught myself just dragging the data into VFP, grinding them there and pushing them back - easier than to do there.