How to convert a string to lowercase characters (Enterprise Manager)

How to convert a string to lowercase characters (Enterprise Manager)

To convert a string to lowercase characters

1. On the Transformations tab of the Transform Data Task Properties or Data Driven Query Task Properties dialog box, click the Source column containing the string to be modified, and then click the Destination column where you want the modified string to be placed.
   
   
2. Do one of the following:
   • If there is a mapping arrow connecting the two columns, click Delete, and then click New.
     
     
   • If there is no mapping arrow, click New.
3. In the Create New Transformation dialog box, select Lowercase String.

See Also

Lowercase String Transformation

Transform Data Task