Subject Re: [firebird-support] cast 'nnn,nn' to float
Author Kjell Rilbe
Michael Ludwig wrote:

> danyschaer schrieb am 27.11.2008 um 19:54:09 (-0000):
>>I am working with a table that have into varchar fields some floating
>>values, but they use a comma as decimal separator (regarding regional
>>Is it possible to cast this values to floating point values??
> I don't think so. You'll have to convert them, replacing commas with
> dots.
> Firebird 1.5 comes with only a minimal set of SQL functions, and it
> doesn't look like that has changed in 2.0. Nothing in there to do string
> replacement. Don't know about 2.1, nor which version you're using.

In Firebird 2.1 you can use replace(str, oldstr, newstr), e.g.
replace("EmailAddress", '@', ' at ') will produce e-mail addresses
slightly more difficult to harvest for spam.

Kjell Rilbe
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64