Convert String to Proper Case ?

[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

 

[Brian]

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

Have a look at StrConv in Help.

 

[Jeff Boyce]

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.

 

[Brian]

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>

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.