LCase tranform on rs.fields

programming
1

Can anyone advice why this does not transform data from a database to lower case text, I have tried all these different codes on and none of them seem to working very well.


<%=rs.fields(LCASE("CategoryName"))%> - Does nothing

<%=rs.fields&LCASE("CategoryName")%> - Error

<% Response.Write "" rs.fields& LCASE(CategoryName) %> - Error

<% Response.Write "" rs.fields& LCASE(CategoryName) "" %> - Error

I am following the VBScript guidelines from w3 Schools but no luck so far