Ebrain,

Thx. It works like a charm.


sorry that i am asking you more.

The query is bit complicated, and whatever i try to moidfy, i am not able to.

Some fileds are coming like host1:12.2.3.4:303

iie., they are coming with port at the end.

I just want to ignore all the data after the second colon ie, igonore 303

Can u pls help me with this modification.

Thanks
sonia