G
Guest
I am having an issue with values having question marks in my table.
Example
Table ABC contains the values W45,W50,U23,U25,R0,Z23 in Field 1
Table CDF has the following records
Field1 Field2
W?? text1
Z2? text2
U?? text3
R0 text4
I want to have W45 and W50 return text1, U23 and U25 return text3, R0 return
text4, and Z23 return text2. I can't just join ABC.Field1 to CDF.Field1
because of the question marks. Any ideas what the SQL or query should look
like to accomplish this?
Any help would be greatly appreciated.
TYIA
Example
Table ABC contains the values W45,W50,U23,U25,R0,Z23 in Field 1
Table CDF has the following records
Field1 Field2
W?? text1
Z2? text2
U?? text3
R0 text4
I want to have W45 and W50 return text1, U23 and U25 return text3, R0 return
text4, and Z23 return text2. I can't just join ABC.Field1 to CDF.Field1
because of the question marks. Any ideas what the SQL or query should look
like to accomplish this?
Any help would be greatly appreciated.
TYIA