>>Hello, is there a way to insert or update a record field in uppercase?
>>
>>Thx.
>
>You can use UPPER function in SQL Server, but usually SQL Server is case insensitive, so the case doesn't really matter.
>
>Anyway, you can use
>
>update myTable set myField = upper(@myParam)
Hmmm,
Usually SQL Server is as it is installed :-)
You can never be sure what collation the administrator is used when (S)He is installed the SQL Server.
Recently we fight with Latin1_General_CS_AS :-)
You only can be sure which collation your database is used if you use COLLATION when you create your Database.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.