LOWER (SQL Server Compact Edition)
Returns a character expression after converting uppercase character data to lowercase.
LOWER ( character_expression )
An expression of character or binary data type, or a data type that is implicitly convertible to nvarchar or ntext.
The following example returns, in lowercase, the list of company names in the Customers table.
SELECT CustomerID, LOWER(CompanyName), City