Make All Rows Lowercase ¦ Update Query

[ukgimp]

Is there a way of apdating all the contents of a feild down multiple rows using a query.

Something like (psuedo code)

UPDATE [Table] SET field = replace(field,'*','toLowerCase (field)');

Cheers

[macrost]

ukgimp,
If you want to have all lower case then you can use:

LCase(field)

Mac

P.S.
UCase will put it in all caps.

[mattglet]

another answer to your question:

yes, that will affect every record in your table. queries only modify records that meet a WHERE clause. if none is present, then all records will be updated.

-Matt

[duckhunter]

I believe the SQL Server commands are LOWER and UPPER
LCASE and UCASE are the VBSCRIPT equivalents.

the SQL Update Statement would be:
UPDATE [Table] SET field = LOWER(field) [WHERE field2 = 'value']

[mattglet]

duckhunter-

that is correct... lower and upper are the keywords to use with SQL. lcase & ucase are strictly vbscript functions.

-Matt