converting data

  • Thread starter Thread starter Haigy
  • Start date Start date
H

Haigy

i have to be able to convert my database from uppercase to normalcase

on each field i am doing strconv([fieldname],3) in an update query to test
it

this works fine for me in most cases, but i have surnames that start with
MC, when i run the conversion on these i get Mccccc, needs to be McCcccc, ie
third letter capitlised

is there a way to do this

thanks in advance
 
Run a second conversion routine to check for MC and change the third
character to an uppercase.

mid([fieldname],3,1)=ucase(mid([fieldname],3,1)) where
left([fieldname],2)="Mc"

Kelvin
 
Back
Top