I have following case:

two fields:
first_name
last_name

People can write their names e.g. Smith (right!), but also smith, SMITH. How i can convert name to right?

I am not sure if I understand you entirely, but assuming you want to convert a name to all upper case or all lower case, you can use VBScript's string functions:

e.g.

strAllUpperCaseName = UCase(strName)

Use LCase if you want all lower case.

This can help: www.asp101.com/samples/pcase.asp

Viktor Farcic

TalkZone Manager

I guess you'd be able to use a CSS Stylesheet as well? There's Uppercase, Lowercase and Capitalize. ??


Tony

___________________
Lunch is on me! <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Edited by - bloodtrain on 27 Apr 2002 09:15:26