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...

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 (k**a@mailcity.com)

thanks, that's not what i was lloking for but can be interesting too ;-)