Need to add upper

[#1]

Right(LastModifiedBy, Len(LastModifiedBy) - 3) as LastModifiedBy,

My data has both upper and lower case but the file I am linking it to is all upper case.

Where dos the UPPER clause go?  Tried a few different ways but no luck.

[agomes1971]

Hi,

     Try like this,

     Load Upper(LastModifiedBy) as LastModifiedBy;

     select LastModifiedBy from your_table;

HTH

André Gomes

[sunny_talwar · Accepted solution]

You can do this:

Upper(Right(LastModifiedBy, Len(LastModifiedBy) - 3)) as LastModifiedBy,

[#4]

Not sure where to put it at

[Rxs]:
LIB CONNECT TO [pharmoresql production (pharmore_rwinkel)];

LOAD
FacID,

Right(LastModifiedBy, Len(LastModifiedBy) - 3) as LastModifiedBy,

PharmID;

SQL SELECT 
FacID,

LastModifiedBy,
PharmID

FROM Rx.dbo.Rxs

[agomes1971]

Instead of

Right(LastModifiedBy, Len(LastModifiedBy) - 3) as LastModifiedBy,

put

Upper(Right(LastModifiedBy, Len(LastModifiedBy) - 3)) as LastModifiedBy,

HTH

André Gomes