View previous topic :: View next topic |
Author |
Message |
adrianjuk
Joined: 09 Dec 2003 Posts: 9 Location: Halifax England
|
Posted: Fri Nov 04, 2005 5:20 am Post subject: SQL Query Syntax |
|
|
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 |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Fri Nov 04, 2005 1:31 pm Post subject: |
|
|
According to SQL rules you should type test_method LIKE 'check UNC%'
Regards
Alex |
|
Back to top |
|
|
adrianjuk
Joined: 09 Dec 2003 Posts: 9 Location: Halifax England
|
Posted: Mon Nov 07, 2005 3:25 am Post subject: SQL Syntax |
|
|
Alex
Brilliant as ever
Thank you |
|
Back to top |
|
|
|