Forums
This topic is locked
convert lowcase and uppercase
Posted 03 Apr 2002 07:00:24
1
has voted
03 Apr 2002 07:00:24 Tommi Virtanen posted:
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?
Replies
Replied 05 Apr 2002 07:08:02
05 Apr 2002 07:08:02 Hank Tan-Tenn replied:
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.
e.g.
strAllUpperCaseName = UCase(strName)
Use LCase if you want all lower case.
Replied 05 Apr 2002 08:21:38
05 Apr 2002 08:21:38 Viktor Farcic replied:
Replied 27 Apr 2002 09:14:58
27 Apr 2002 09:14:58 Tony Chronopoulos replied:
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
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