Hi, I would appreciate help on the following. I have a column in a table. Each entry in the column can have 0,1,2,3... maybe four entries in it.
I would like to parse the column and grab each of the entries and feed it into another select statement. This entry that needs to be parsed would be found through a select statement. I would like to know what a good way is for doing this. For example an entry in the column may be AI732541 AI791498 AA508861 another entry may be AA508867 Basically, in the first example AI732541 AI791498 AA508861 would be the the answer ie. access_num for my first select statement Select access_num from inventory where prod_id = current_prod_id; I would like to parse the entry to allow me to access AI732541 to feed into another select statement find out the answer and capture in a variable. Then I would like to be able to access the next entry AI791498 and perform the same task of feeding it into another select statement and capturing the answer in a variable an so on. thanks in advance --------------------------------- Post your free ad now! Yahoo! Canada Personals