Found a way around my problem that appears to work well. As I stated before, I dynamically create a view of the table being bulk-inserted into. I did a little trickery using Substring() in conjunction with the Ltrim() and Rtrim() functions. As I'm dynamically building the view, I can sniff out a row of the target data, determine which fields have quotes surrounding the data within, and add in the Substring() to that field's criteria in the view when creating the view. Nifty. :)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
