I am trying the following code and not getting any results. The like is looking in a lookup table to see if there is anything similar to what is in the original table. The original Table is populated by a spreadsheet where the user may not enter the value exactly as it appears in the lookup table. Am I doing this correctly, or is there a better way of doing it?
thanks in advance!
Tazzmann
thanks in advance!
Code:
Select a.Plan_Number,
a.Plan_Name,
a.Customer_ID,
b.BasisID,
a.Last_PE_Before_BBSI,
a.PT_Number,
a.Accrual_On_Checks,
a.Available_On_Checks,
a.Can_Accrue,
a.Can_Carry_Over,
a.Add_Existing_Emp,
a.Add_New_Emp
FROM dbo.tmp_PTO_AccesstoSQL a,
dbo.tlkp_PTO_Plan_Basis b
Where a.Plan_Basis like '%' + b.basis_desc + '%'
Tazzmann