|
 |
asp_web_howto thread: i want to convert my data to Upper Case
Message #1 by "taherm@f... on Thu, 20 Sep 2001 17:22:43
|
|
dear friends
i am using sqlserver and i want to convert all values in my itemcode filed
to uppercase . if this would be an access database iwould have placed ">"
sign in my default and then any data entered would be converted to Upper
Case automatically.
i want to do the same.
in whatever case (upper or lower or mixed) the data is entered by the user
in the itemcode field from a webbased screen it should get converted to
uppercase in my database.
i am **not** looking for any client side asp script but looking for script
on my SQLSERVER whih does this.
Any suggestions will be greatly appreciated
Regards
Message #2 by "Drew, Ron" <RDrew@B...> on Thu, 20 Sep 2001 12:56:48 -0400
|
|
stritemcode = UCase(Request.Form("itemcode"))
on the server itself, you may want to run this so any prior input is
converted
UPDATE TABLE SET itemcode = UPPER(itemcode)
-----Original Message-----
From: taherm@f...
[mailto:taherm@f...]
Sent: Thursday, September 20, 2001 1:23 PM
To: ASP Web HowTo
Subject: [asp_web_howto] i want to convert my data to Upper Case
dear friends
i am using sqlserver and i want to convert all values in my itemcode filed
to uppercase . if this would be an access database iwould have placed ">"
sign in my default and then any data entered would be converted to Upper
Case automatically.
i want to do the same.
in whatever case (upper or lower or mixed) the data is entered by the user
in the itemcode field from a webbased screen it should get converted to
uppercase in my database.
i am **not** looking for any client side asp script but looking for script
on my SQLSERVER whih does this.
Any suggestions will be greatly appreciated
Regards
Message #3 by Greg Griffiths <griffiths@x...> on Fri, 21 Sep 2001 17:22:38 +0100
|
|
SQL uses the upper() so you could so something like :
INSERT INTO myTable (name) VALUES (upper(username))
At 17:22 20/09/01 +0000, you wrote:
>dear friends
>i am using sqlserver and i want to convert all values in my itemcode filed
>to uppercase . if this would be an access database iwould have placed ">"
>sign in my default and then any data entered would be converted to Upper
>Case automatically.
>i want to do the same.
>in whatever case (upper or lower or mixed) the data is entered by the user
>in the itemcode field from a webbased screen it should get converted to
>uppercase in my database.
>i am **not** looking for any client side asp script but looking for script
>on my SQLSERVER whih does this.
>
>Any suggestions will be greatly appreciated
>Regards
|
|
|
View Cart
