Convert String to Proper Case ?

  • Thread starter Thread starter Luqman
  • Start date Start date
L

Luqman

Which function in Microsoft Access 2003 will convert string to Proper Case
through Sql ?

for example:

Select proper('LUQMAN') from mytable
should return Luqman

Best Regards,

Luqman
 
Luqman said:
Which function in Microsoft Access 2003 will convert string to Proper Case
through Sql ?

for example:

Select proper('LUQMAN') from mytable
should return Luqman

Best Regards,

Luqman
Click to expand...

Have a look at StrConv in Help.
 
Be aware if you are looking to "proper case" some names that this function
ONLY (that should have been Only) upper cases the first letter.

Names like

O'brien
Macdonald
Van De Waals
Detray

are not handled the way you might want. For more on capitalization of
proper names, check the mvps.org website.
 
Jeff Boyce said:
Be aware if you are looking to "proper case" some names that this function
ONLY (that should have been Only) upper cases the first letter.

Names like

O'brien
Macdonald
Van De Waals
Detray

are not handled the way you might want. For more on capitalization of
proper names, check the mvps.org website.

--
Good luck

Jeff Boyce
<Access MVP>
Click to expand...

A truly comprehensive Proper Case routine is impossible, there are just too
many variations and unknowns. You've given some good simple examples above:
MACDONALD might validly be either MacDonald or Macdonald. VAN DE WAALS
might be Van de Waals or Van De Waals. In fact, of the examples you've
given, the only clear-cut one (which StrConv will definitely get wrong) is
O'Brien.

If you start to investigate all the possible variations on capitalisation
throughout the world's languages and nationalities, you soon see that it is
hopeless.
 
Back
Top