var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: LIKE Query
Hi everyone, I have another problem.
My application is coded in VB6 using DAO 3.6.
The Access DB has a table which is linked to a csv file. Consquently, some fields in the DB table have left padding on them (e.g " value")
What I need is to be able to join this table with another.
Is there a correct way to do this? Or will I have to remove the padding?
SELECT tblImport.Name, tblImport.RID, tblTruck.RID
FROM tblImport, tblTruck
WHERE tblTruck.RID LIKE %tblImport.RID ?????????
ON tblTruck.RID = LTrim(tblImport.RID)