I'm not sure how you would do this with a SQL statement, but how about
pulling out the data and splitting the string in code. Once the string is
split and all the data is in an array, you could manipulate it as needed.
Microsoft MVP - ASP/.Net
Windows 2000 MCSE
Powerful Web Hosting Solutions
#1 in Service and Support
"Mike" <com> wrote in message