Hello,

I have names and telephone numbers of various people stored in one field in an oracle db. If there is more than one name and number in the field the names and phone numbers will be separated by "~~", which vbscript substitutes for carriage returns in my script.

I have an instr Function in this script that searches a string this character, e.g.

dim posmarker as string
dim strContacts as string


strContacts = rsTemp("contact_telephone")
posmarker=instr(1, strContacts,"~~")

This does tell me the position when there is a second name and telephone number. Now if i want to exclude all names and numbers that follow "~~" in the oracle db field how would i go about it?

anybody any ideas?

Many thanks