Text Format for query

J

Jan

The table has text stored in a field both in UPPER Case and Proper Case. How
can I format the text on a query to return Proper Case?
 
D

Douglas J. Steele

SELECT StrConv([MyTextField], 3) FROM MyTable

Note that this will only work if you're running the query from inside of
Access. If, for example, you tried to run the query from, say, VB or ASP, it
will fail.
 
Top