SELECT SUBSTR('199.171.216.254:22808 ',1,INSTR('199.171.216.254:22808 ',':')-1) FROM DUAL

Hope this helps
Gregg