# LCase tranform on rs.fields

**URL:** <https://forum.kirupa.com/t/lcase-tranform-on-rs-fields/284839>\
**Category:** programming\
**Created:** [March 24, 2009, 9:23am UTC](https://forum.kirupa.com/t/lcase-tranform-on-rs-fields/284839 "2009-03-24T09:23:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Env](https://avatars.discourse-cdn.com/v4/letter/e/d9b06d/32.png) [@Env](https://forum.kirupa.com/u/Env)\
**Post date:** [March 24, 2009, 9:23am UTC](https://forum.kirupa.com/t/lcase-tranform-on-rs-fields/284839/1 "2009-03-24T09:23:28Z")

</div>

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.

```auto

<%=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