Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2785
  • Last Modified:

lcase/ucase functions

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
JuniorBee
Asked:
JuniorBee
  • 2
  • 2
1 Solution
 
fritz_the_blankCommented:
This might help:

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

You are looking for Upper() and Lower()

FtB
0
 
JuniorBeeAuthor Commented:
Wonderful!  Thanks! =)
0
 
JuniorBeeAuthor Commented:
Oh Wow That link is awesome!  

Big Grins =)))
0
 
fritz_the_blankCommented:
You are welcome. I had to learn the same thing myself not so long ago.

Happy programming,

FtB
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now