hi all,

i have a question about input and regional settings.

i know there is an attribute in SQL (SQL_SOPT_SS_REGIONALIZE, you can have a look
at : http://msdn.microsoft.com/library/psdk/sql/od_odbc_s_8pv6.htm) that deals
with output regional settings, the database display the value with the client's
regional settings.
(when the numeric settings of the database are different then the user's one, for
exemple if in US you have 1,250.25 it will be 1.250,25 in french or german).

is there something for the input ? i mean the user enter a numeric value and the
database converts the value, based on the user's regional settings

i know that we can interprate a numeric value and change it with a code (in VB in
my case), but it's not a clean method, and some exceptions will always be
forgotten. It would be better to let the SQL server do this.

any idea ?

best regards,
elise
ps : thanks to post the answer at my personal email too (kea@mailcity.com)