Capitalize the first letter

[Cleung]

How to capitalize the first letter in a query?

 

[RV]

Search the forum for "capitalize"

RV

 

[Cleung]

I think I havn't make my question clear. I have a field in a table that have already been filled with data in captial. I want to make a query with the first letter capitalized. I know there should have some simple function that can perform this job. I have tried to search the forum, but nothing related to my questions.

 

[David R]

What happened when you typed capitalize into the search engine here? There are several different ways to do what you're asking in a query.

 

[RV]

Your question is still not clear to me.
I gues though you could find out whether the StrConv Function suites you.

RV

 

[cogent1]

PROPER

You need the PROPER procedure. I think this is an inherent function in Access2000, like LCase or Ucase..

If you need the function for Access97 post a request and I'll send

 

[Jon K]

Let's use a City field as an example. Suppose you want to display the cities as:
London
New York
Singapore

use this:

SELECT StrConv(City,3) as ProperCity
FROM yourTable;


If you want to capitalise only the first letter, use either this:

SELECT UCase(Left(City,1)) & LCase(Right(City,Len(City)-1)) as FirstLetterOnly
FROM yourTable;

or this:

SELECT UCase(Left(City,1)) & LCase(Mid(City,2)) as FirstLetterOnly
FROM yourTable;


They change the cities to
London
New york
Singapore