comma in a query

[jscriptor09]

Hi folks
In Europe, the decimal seperator is "," as in 2500,35.  In the US and several other parts of the world it is a "." as in 2500.35

the value is a double.

so for a query like this "Select x from y where z-" & thePrice & ".....

with PC Regional set to France, thePrice is 2500,35.

The query fails.

if I change to 'thePrice' I get an error of missmatch type.
Any idea how to deal with this issue? and get the query to work?
Thanks
Mike

[June7]

Maybe need to double the comma so it will be accepted by the SQL as literal character. That works with apostrophes.

"Select x from y where z=" & Replace(thePrice, ",", ",,") & "

Is this web page coding (& suggests that)?