You could do a replace on the list, adding a space between the double delims (CF ignores empty list elements), then in your insert/update statement, set the value to NULL (or whatever) if the list value is a single space.
Cheers, Kris > I have this pipe delimited list > suppose A||C > Now the middle one is blank. How can i store this list so that i can track > the middle one as blank and later when i update the DB i can update this null > as something else in DB? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
