Solved

lcase/ucase functions

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Save ms data to server side. 19 63
Filktering Alphabetically 8 45
I need to Integrate Hubspot into my .asp application but don't know how to POST 11 50
Hide and Unhide Table 6 39
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…

738 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