I'm using Delphi, ADO and Access 2000. I just want to do a substring in my where statement like :
delete from test_inspection
where substring(no_test_code, 1, 1) = '3'
The substring function doesn't seem to work. What is the ringht function? I will have done this with Oracle and it will have taken 30 seconds to do but currently, I'm not able to find the right function to call to do that.