• 

  Gary

  88 posts since
  Feb 26, 2008

  Currently Being Moderated

  1. Jan 27, 2010 6:30 AM (in response to Singh)

  Re: Converting whole table into UPPER CASE

  unless some-one can come up with a flashy way, you will need to do a CTAS selecting UPPER(fieldname) for each field

  • Report Abuse
  • Like (0)
• 

  David Shuttleworth

  270 posts since
  May 14, 2008

  Currently Being Moderated

  2. Feb 1, 2010 8:01 AM (in response to Gary)

  Re: Converting whole table into UPPER CASE

  If there are many tables to do this for, it may be worth creating an SQL query that will generate the CTAS statements with UPPER(colname) for Character columns from the appropriate system catalog tables.

   

  D.

  • Report Abuse
  • Like (0)