ODBiC Discussion Board


RE: Try it without the brackets around column names, Roger Harris, 04-23-2007

Got It!

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.

John


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


Copyright ©1997-2003, Roger Harris. All rights reserved.