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
Solved

lcase/ucase functions

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used.

789 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