I have a record in the db in caps like "FORM" is there someway I can printit out in the ASp page not allin caps but like this "Form"<BR>please let me know<BR>thanks
Yes.<BR><BR>Using InStr, Lcase the rest of the word, but don't include the first letter.<BR><BR>If you're using regular VB, you can use the StrConv function, and pass it vbProperCase.
say Rs("name") contains FORM then<BR><BR>Str=Rs("name")<BR>Response.write Ucase(Mid(Str,1,1))& Lcase(Mid(Str,2))
a = "FORM"<BR>a = Left(a, 1) & LCase(Right(a, Len(a) - 1))
thanks can you give me the syntex....<BR>i am reading it like this <%=rs("fieldname")%>in asp<BR>thanks
you will notice that TWO people have already given you the syntAx