dts export

• bruce_reid

  SSCrazy

  Points: 2419

  More actions

  April 21, 2003 at 6:23 pm

  #80073

  I have a table with first_name , last_name,state and zip columnswhen exporting my table data into text file i would like to change the first letter of the first_name should be capital(Davis,John) and the state column value should be capitol(NJ,PA,,).How to do that.

• DubNoBass

  SSC Rookie

  Points: 27

  More actions

  April 22, 2003 at 3:05 am

  #454871

  You could have a view based on the data, using the following expressions:

  For proper case on first name and last:

  UPPER(SUBSTRING(first_name, 1, 1)) + SUBSTRING(first_name, 2, 255) AS first_name

  For upper case on state, use:

  UPPER(state) AS state

  Then DTS out the View...That should do it.