Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can do this:
Upper(Right(LastModifiedBy, Len(LastModifiedBy) - 3)) as LastModifiedBy,
Hi,
Try like this,
Load Upper(LastModifiedBy) as LastModifiedBy;
select LastModifiedBy from your_table;
HTH
André Gomes
You can do this:
Upper(Right(LastModifiedBy, Len(LastModifiedBy) - 3)) as LastModifiedBy,
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
Instead of
Right(LastModifiedBy, Len(LastModifiedBy) - 3) as LastModifiedBy,
put
Upper(Right(LastModifiedBy, Len(LastModifiedBy) - 3)) as LastModifiedBy,
HTH
André Gomes