Text Format for query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count text values in a Access Field 0
Case-sensative query 5
Simple update query question 3
Need to find lower case entries in a table 2
How to query a text string when case is in upper and lower 3
detecting unwanted characters 7
Update Query to Force Field to Uppercase in Table 2
Changing UPPER to Proper Case 1

Back
Top