INSTR Help

From: Jenny Farnham <farnham_at_spot.colorado.edu>
Date: 14 Mar 2001 00:42:04 GMT
Message-ID: <98meos$kmq$1@peabody.colorado.edu>

Here is a puzzle!

A text field contains this info:

TEXT

---

Split = 25% of $8715.27 Value Before Uplift

I want to put parenthesis around the words:

Value Before Uplift

I can easily get the one on the end by taking the field and doing:

set text = text || ')'

HOW DO I get the right parenthesis to be before the word Value?

Ulitimately I want:

Split = 25% of $8715.27 (Value Before Uplift)

I'd love to have this in a simple update statement:

update sometable
set text = ?????????? solution ???????

Any ideas?

Jennifer in Colorado Received on Tue Mar 13 2001 - 18:42:04 CST