Extracting a value from a string

[richard_chilvers]

My table has a field which contains notes with a value in. For example:

"The cost of the purchase is £234.56 payable by cheque"

I wish to extract the numeric part as a value.

I have used TextBetween(NOTE_TEXT,'£',' ') AS Value

which works well, except sometimes there is no space after the value, eg.

"The cost of the purchase is £234.56per person payable by cheque".

Is there anyway I can identify the TextBetween '£' and a non-numeric character?

Thanks

[#2]

Here you go..

SubField(SubField(NOTE_TEXT,'£',2),' ')

Thanks,

Prabhu