lower case to upper case

[j0rdanf1]

hi people,

I have rather an odd question, all the information I have inputted into my aql database is lower case, however, on some of the pages i display i want to retrieve the code in an uppercase format, is their any straight forward way to do it?

Cheers,

<%
 
Dim  strbasicsearch, strSQL, objConn, objRs
strbasicsearch = Request.QueryString ("basicsearch") 
 
strSQL = "select * from album where band_name like '%"& strbasicsearch &"%'"
 
 
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "dsn=Oracle;uid=user;pwd=pass"
Set objRs=objConn.Execute(strSQL)
 
 
<table>
<tr>
<td width="400" valign="middle" class="style10"><strong><%=objRs("band_name")%></strong> </td>
</tr>
</table>
 

[markrawlingson]

That is weird. Have you tried running a query directly in the database and see what you get back?

By the way, you can also use the LCase() and UCase() functions to change the case. So if you want everything in lower case, you could use the LCase function to get there.

[j0rdanf1]

That is weird. Have you tried running a query directly in the database and see what you get back?

By the way, you can also use the LCase() and UCase() functions to change the case. So if you want everything in lower case, you could use the LCase function to get there.

great, but how would i attach the Ucase() function to the requested code?

[marting]

Hi

You can use the UCase() and LCase() like this...

<%=UCase(objRs("band_name"))%>

<%=LCase(objRs("band_name"))%>

Because I'm sooooo kind, I'll add your code below with UCase() applied.

<table>
<tr>
<td width="400" valign="middle" class="style10"><strong><%=Ucase(objRs("band_name"))%></strong> </td>
</tr>
</table>

Enjoy...

[j0rdanf1]

You are a legend, thank-you my friend that has solved a big problem

Hi

You can use the UCase() and LCase() like this...

<%=UCase(objRs("band_name"))%>

<%=LCase(objRs("band_name"))%>

Because I'm sooooo kind, I'll add your code below with UCase() applied.

<table>
<tr>
<td width="400" valign="middle" class="style10"><strong><%=Ucase(objRs("band_name"))%></strong> </td>
</tr>
</table>

Enjoy...