Upper case join

[BlurredVision]

I have the following select statement which joins two views together. In one view the First_Name is in all caps, in the second view, the First_Name is stored in lower case. Is there a way I can conver the first_name in lower case to all upper?

Thanks for any help given.


SELECT "RV_tmpOIG"."UPIN", "RV_tmpOIG"."LastName", "RV_tmpOIG"."FirstName", "RV_Practitioner"."First_Name"
FROM "MSOW_QA"."dbo"."RV_tmpOIG" "RV_tmpOIG" INNER JOIN "MSOW_QA"."dbo"."RV_Practitioner" "RV_Practitioner" ON ("RV_tmpOIG"."LastName"="RV_Practitioner"."First_Name") AND ("RV_tmpOIG"."FirstName"="RV_Practitioner"."First_Name")

 

[bikerboy718]

Use the Upper Command.

For Example:

SELECT "RV_tmpOIG"."UPIN", "RV_tmpOIG"."LastName", "RV_tmpOIG"."FirstName", UPPER("RV_Practitioner"."First_Name")
FROM "MSOW_QA"."dbo"."RV_tmpOIG" "RV_tmpOIG" INNER JOIN "MSOW_QA"."dbo"."RV_Practitioner" "RV_Practitioner" ON ("RV_tmpOIG"."LastName"="RV_Practitioner"."First_Name") AND ("RV_tmpOIG"."FirstName"="RV_Practitioner"."First_Name")

With Great Power Comes Great Responsibility!!!

Michael

 

[bikerboy718]

To make this a bit more clearer:

SELECT "RV_tmpOIG"."UPIN", "RV_tmpOIG"."LastName", "RV_tmpOIG"."FirstName", [red]UPPER("RV_Practitioner"."First_Name")[/red]
 FROM   "MSOW_QA"."dbo"."RV_tmpOIG" "RV_tmpOIG" INNER JOIN "MSOW_QA"."dbo"."RV_Practitioner" "RV_Practitioner" ON ("RV_tmpOIG"."LastName"="RV_Practitioner"."First_Name") AND ("RV_tmpOIG"."FirstName"="RV_Practitioner"."First_Name")

With Great Power Comes Great Responsibility!!!

Michael