Solved

lcase/ucase functions

Posted on 2006-06-14
4
2,768 Views
Last Modified: 2008-01-09
Argh!

MSSQL database does not recognize lcase() or ucase()?  Argh!
Is there another function for this purpose when using ASP to connect to a MSSQL db?

Also, does anyone happen to have a website that references functions for MSSQL compared to Access?  I'm upgrading =)
0
Comment
Question by:JuniorBee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 46

Accepted Solution

by:
fritz_the_blank earned 500 total points
ID: 16906017
This might help:

http://www.aspfaq.com/show.asp?id=2214

You are looking for Upper() and Lower()

FtB
0
 

Author Comment

by:JuniorBee
ID: 16906084
Wonderful!  Thanks! =)
0
 

Author Comment

by:JuniorBee
ID: 16906093
Oh Wow That link is awesome!  

Big Grins =)))
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 16906108
You are welcome. I had to learn the same thing myself not so long ago.

Happy programming,

FtB
0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question