shakir — Tue, 27 Nov 2007 06:44:52 +0000

Convert the price to integer. now it will be string

Greg K — Fri, 19 Oct 2007 23:17:50 +0000

I just made a test table, with one field `desc` and put your line in it. I then execute the following:

SELECT (substring(`desc`,instr(`desc`,'£')+1)*4) as VAR1 FROM `test`'

and the result back from mySQL is 3200, which is correct. Can you give an example of how you are trying to do it.

-Greg