hi,
SQL newbie here...using MySQL to be exact.
i want to convert a column of emails to be all lowercase.
is this possible?
i've searched this and other forums to no avail.
thanks for your help

Of course you can:

Try using the LOWER Function when updating your field.

thanks, but maybe i wasn't clear.
i have a whole table already filled with data and i need to run a script that updates all of the exisiting data in a column and converts all the data to lowercase.
i'm an SQL newbie...is this possible?
something like:
UPDATE table SET column = LOWER() ???

UPDATE table SET column=LOWER(column) ?

ah, very nice thanks!