How to remove period from a string

[JohnA]

I am needing to remove the period from a text string field
Ex: 123.45 or
V123.45

How would you simply display the result of: 12345 or V12345, with no period?
Thanks

[jive]

If you work with oracles you can used this function
SELECT REPLACE('V123.45
′,'.',") COL1 FROM DUAL;
result will be 'V12345'
In cognos I think the function SUBSTITUTE will do the same.

Regards Jacques