SQL Query Syntax

[adrianjuk]

Hi

I have tried the fix you suggested for access violation in Loganalyser to upgrade to V5.04 and added the two lines suggested and it worked Thank you

I am now populating an Access 2000 database as a test before moving it to SQL 2000 and I am having a little difficulty with SQL syntax

If I want to list all the check process tests, I enter Test_Method='check process' and that works fine

What I need to do is to list all the check UNC tests but the test method varies according to the size that has been set in the threshold of the test

I have tried things like Test_Method like 'check UNC*' but everything I have tried returns 0 records

Am I missing something? Or could this be something to do with Access?

Regards

[KS-Soft]

According to SQL rules you should type test_method LIKE 'check UNC%'

Regards
Alex

[adrianjuk]

Alex

Brilliant as ever

Thank you