Using the Euro symbol

[Col]

I have an Access front end to a SQL Server 2005 database using ODBC linked
tables. There appears to be a problem when using the euro symbol in queries.

SELECT *
FROM tbl_Datatable
WHERE (tbl_Datatable.strPRICE)='?40';

This query returns nothing although there are many entries with a strPRICE
of '?40'


SELECT *
FROM tbl_Datatable
WHERE (tbl_Datatable.strPRICE)='$40';

This query returns all with a strPRICE of '$40'


How do I use the symbol in queries?

Regards

Colin

 

[Trey Walpole]

I have an Access front end to a SQL Server 2005 database using ODBC linked
tables. There appears to be a problem when using the euro symbol in queries.

SELECT *
FROM tbl_Datatable
WHERE (tbl_Datatable.strPRICE)='?40';

This query returns nothing although there are many entries with a strPRICE
of '?40'


SELECT *
FROM tbl_Datatable
WHERE (tbl_Datatable.strPRICE)='$40';

This query returns all with a strPRICE of '$40'


How do I use the symbol in queries?

Regards

Colin

Looks more like the display could be showing a "?" because it isn't
reading the € correctly. Or was that just in the post? Can't tell.

Why is the price a string? Seems like it would be better to have an
amount and a currency. (e.g., where price=40 and currency='euro'). Then
the display UIs should handle the symbol.