try
select (ucase(left(name,1))+lcase(mid(name,2,len(name))) from teststring

I've added in left().  Not sure why it worked to start with.

Gillian
----- Original Message -----
From: "Roy, Siddarth S" <sroy@b...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, August 15, 2002 5:19 PM
Subject: [asp_databases] RE: MSDE2000


Hi guys

I have a access probelm i give a query in the access feild which i want to
take the first letter in the uppercase

select (ucase(name,1)+lcase(mid(name,2,len(name))) from teststring
it works fine

when i use the update query

update teststring where name=select
(ucase(name,1)+lcase(mid(name,2,len(name))) from teststring
update teststring where name=(select
(ucase(name,1)+lcase(mid(name,2,len(name))) from teststring )

both  gives me a syntax error.Where exactly am i going wrong .can anybody
give me some pointers

thanx in advance
sid

I am sorry for that typo . i didnt include the left in it
Well i am not able run the updateable query for it

any pionters please
tia
sid


-----Original Message-----
From: Gillian Harber [mailto:gillian@m...]
Sent: Thursday, August 15, 2002 12:55 PM
To: ASP Databases
Subject: [asp_databases] first letter in the uppercase


try
select (ucase(left(name,1))+lcase(mid(name,2,len(name))) from teststring

I've added in left().  Not sure why it worked to start with.

Gillian
----- Original Message -----
From: "Roy, Siddarth S" <sroy@b...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, August 15, 2002 5:19 PM
Subject: [asp_databases] RE: MSDE2000


Hi guys

I have a access probelm i give a query in the access feild which i want 
to
take the first letter in the uppercase

select (ucase(name,1)+lcase(mid(name,2,len(name))) from teststring
it works fine

when i use the update query

update teststring where name=3Dselect
(ucase(name,1)+lcase(mid(name,2,len(name))) from teststring
update teststring where name=3D(select
(ucase(name,1)+lcase(mid(name,2,len(name))) from teststring )

both  gives me a syntax error.Where exactly am i going wrong .can 
anybody
give me some pointers

thanx in advance
sid