Lower to Upper Case Text Conversion

[craigfw]

Hey everyone,

We need to convert text inserted into a form's input field in mixed case (Last Name) into Upper Case for loading into a MS SQL Server 2000 table. The insert already works, we just need to convert the text. Has anyone done this sort of conversion?

Thanks in advance,

Craig Webber

 

[ChrisHirst]

assuming ASP use ucase(string)

Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[craigfw]

Thanks,

What we're REALLY looking for, after consulting the developer again, is a Java Script, client-side form validation solution. This will change the text to UPPERCASE in the application prior to submission to the SQL Server.

 

[lebisol]

http://javascript.internet.com/forms/all-upper-case.html

All the best!

by the way...Client Side is NOT 100%..all they have to do is disable JS....use the DB field properties for format
eg. MSAccess
in querry
Corrected_LName: UCase(Users!LName)

All the best!

:--------------------------------------------------------------------------:

ok,ok...I did shoot the deputy but he told me he was the sheriff!
:--------------------------------------------------------------------------:

 

[craigfw]

Thanks to both of you for your suggestions. This solved a problem my web developer has been dreading (he worries alot).