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

[nittin14]

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

[dwadish]

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.

[nittin14]

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.

[dwadish]

Thanx

frnd i send only the idea for that problem.

thanx for the code.


grow