>select cast(pcost as real) / 100 from

Sorry, I forgot. It may require

select (cast(pcost as real) / 100)) as GBP from ...

and of course, such a column cannot be updateable.

Set