Solved

lcase/ucase functions

Posted on 2006-06-14
4
2,764 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
  • 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

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…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

809 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