> I have a string 'PORT1/PORT2/PORT3'.
> Is there a way for me to take only the 1st port when the length of

the

> port is not fixed into specific number of character?

probably have to write yourself a udf to search for the slashes.

Kevin.