I have capitalised words in my sql database. does anyone know how change these to lower case<BR><BR>Any help would be great
Read & Update the records using lcase(myRS("myField"))
do you mean in ASP? you didn't actually say what the db is unleass by sql db you meant "SQL server"?<BR><BR>you could just write some ASP to loop through all the records amending them and use the LCase function of vbscript.
yes i meant when i write the records to the page.<BR>
Response.Write (lcase(myRS("myField"))) ' output in LowerCase Only