I'm new to Sql 2000 and want to convert data in a field to Title case
field is Site_Name
I can do set site_name=upper(Site_name) ---- returns for example BLOGGS LIMITED
but I want this to end up as Bloggs Limited -
only way at present is to export the data to foxpro use a convert string proper(fieldname) and then go back and do an import and update!!!
seems a very long winded way around it