Name Normalization Query

[shexe]

Happy Friday!



Wondering if there is a way for me to normalize case in names. For Instance "Doe, jOhn" to "Doe, John".

I am not familiar with any functions that will allow me to do this, any insight?

Thanks,
Sam

[NTC]

Yes this feature exists in VB. You will want to look up the ProperCase function and apply it.

[pbaldy]

Take a look in Help at the StrConv function.

[shexe]

Thanks for the insight!