String Manipulation

[Jeffrey G. Ubalde]

Good day list!


I have been thinking about this for hours, and I cant quite get the
correct keyword for me to search it in the manual.

for example i have a field that contains string1:string2:string3
where colon ':' is the delimiter.

How do i create a select statement that only returns string2?


Thank you all in advance.

-- 
Jeffrey G. Ubalde
Business Systems
Meridian Telekoms Inc.