RE: Try it without the brackets around column names, Roger Harris, 04-23-2007
by John, April 23, 2007 16:33
It was single quotes ,',' so:
<!--UPDATE plog SET plog.InvoiceIDNum = Left(AddressInvoice,InStr(1,AddressInvoice,',')-1)-->
did the trick. Also, there was some junk data in the AddressInvoice Field that messed things up for a sec, but I delete it prior to update and viola!
Thanks for the help Roger.
Name E-mail optional TopicMessage:
HTTP Link: Link text: