in reply to SQL pulling information

Looks to me like you have a significant design problem. The elements divided by the | should normally be split out into another table unless you have compelling reasons for leaving them together like that.

rdfield