Capitalizing first letter of data in a query

  • Thread starter Thread starter Sarah at DaVita
  • Start date Start date
S

Sarah at DaVita

I have a query that creates a table. Some of the data contains all caps. I
would like to have the first letter of each word capitalized - CENTRAL
DIALYSIS CENTER would become Central Dialysis Center. I can do this in SQL
using the initcap function. I tried this in the SQL view of the query but it
was not recognized. Can someone help me with this?
 
Use the StrConv function. Since you're running in a query, you must provide
the value for the conversion factor (3) as opposed to using the named
constant (vbProperCase)
 
Back
Top