Is there SQL code that is similiar to the Excel Lookup feature? For example, I have an excel sheet that has Codes and District names, and a sheet with just District names. Using the lookup feature in Excel I can make the sheet without the codes (Which are not written exactly like those in the sheet WITH the codes) match up and give me the codes on the other sheet.
However, I tried doing this iN SQL with the "like" command (Thinking that if Albany School D is LIKE Albany School District, it would work) and it doesn't do.
Any suggestions?
J
However, I tried doing this iN SQL with the "like" command (Thinking that if Albany School D is LIKE Albany School District, it would work) and it doesn't do.
Any suggestions?
J