changing UPPER CASE letters to lower case doable? (1 Viewer)

[Espinoza84]

Suppose I have a table, that has 2x columns: FIRST_NAME and LAST_NAME

some of the data in these fields are all in UPPER case while in others are all in Lower Case.

Because, these are first and last names, I would like to change them to have the first letter to Upper case and the rest of the letters to lower case, I would like to do this for each of these 2x columns.

Is this doable? if so how is it accomplishable?

Thank you.

 

[raskew]

Hi -

In the help file, lookup the strConv() function and, more specifically, vbProperCase.

HTH - Bob

 

[odin1701]

Put this in the field name for the query:

FName: UCase(Left((LCase([FIRST_NAME])),1)) & Right((LCase([FIRST_NAME])),(Len([FIRST_NAME])-1))

Repeat with the other field.

 

[Espinoza84]

Thank you both for your help

 

[jfgambit]

The String Conversion Function will accomplish this:

StrConv([FIRST_NAME],3)
StrConv([LAST_NAME],3)

 

[odin1701]

Hi -

In the help file, lookup the strConv() function and, more specifically, vbProperCase.

HTH - Bob

I don't think you can use that in a query...not positive.

But that will work in VBA I know.

Ahh - jfgambit is right - have to use the number, not text.

 

[raskew]

I don't think you can use that in a query...not positive.

Sure can. Here's a working, tested, sample SQL that returns [AccountType] in vbUpperCase.

SELECT tblAccounts.AccountID, StrConv([AccountType],1) AS Expr1
FROM tblAccounts;

Bob