I have a query which calls a function, the function returns some values and at same time does some error trapping and inserts data into a log table.
Select countryCode, GetName(countryCode) from countryTable;
GetName( ) will look for some data in some other table, if found it will return the...
The requirement is to write a query where on one column the retreived data should contain the first letter to be capitalized. The required functionality is same as PROPER function of Excel. This has to be done in MS Access. Any suggestions ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.