By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,061 Members | 1,563 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,061 IT Pros & Developers. It's quick & easy.

how to change the case of data in data list while retreive frm database

P: 16
helo every1,
pls solve my problem
i m showing data in data list using asp.net 2003
My problem is

FirstName // column name in datalist
RAVI
ANIL
AMIT

I want this data is show like this

FirstName // column name in datalist
Ravi
Anil
Amit
Apr 24 '07 #1
Share this Question
Share on Google+
3 Replies


100+
P: 129
change the case of the column except the first character.

cut the first character of the length and change after string to lowercase(string) function.

and add the first letter to the string and display .

you can do it with a loop so every field can change this mode.

try it.
Apr 24 '07 #2

P: 16
thanks
u ans is not working properly but it give enough idea about how to solve this problem

the solutin is :

UPPER(SUBSTRING(FirstName,1,1)) + LOWER(SUBSTRING(FirstName,2,LEN(FirstName)))

change the case of the column except the first character.

cut the first character of the length and change after string to lowercase(string) function.

and add the first letter to the string and display .

you can do it with a loop so every field can change this mode.

try it.
Apr 25 '07 #3

100+
P: 129
Thanx

frnd i send only the idea for that problem.

thanx for the code.


grow
Apr 25 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.