uppercase in SQL???

[hspc]

sure
in SQL Server : use the UPPER() function

SELECT UPPER(lastname) from employees

in Access : use UCase

SELECT UCase(lastname) from employees