Query to remove characters

[KenshiroUK]

Hi all I have a current file with GBP 12.00. I wish to remove the GBP in a make table query when ran to print off.

 

[jdraw]

?? In plain English--more info

You have a file or a table?
Is GBP a field name or part of a data value?
Please give a sample of What you have(input), and what you want(output).

 

[CJ_London]

try

Replace(myField,"GBP ","")