CAPITALS in order form

[TiggyPig]

Is there a way of automatically converting details submitted by customers into capitals?

Does my head in when people cannot use capital letters and everything is typed in lower case. Be easier if when an order was downloaded it could be formatted so that all the order address details are in caps.

Can this be done?

[Jan]

If you have access you could run a SQL statement on the persons table to convert the fields in the person table to uppercase.

Why did you choose uppercase rather than capitalised?

I am thinking about writing a batch order processor to do this, so the scenario would be that orders would arrive and the address details would automatically be formatted, it could also do stuff like convert U.K. and United Kingdom etc to the same string to allow analysis by country to be more accurate.

If anyone things that this is a good idea let me know (by email please jan@mole-end.biz ). Also if you have any ideas for other related useful functionality for this program let me know.

Regards,