jack niekerk
asked on
USING SQL IN VB6 WITH PERVASIVE SQL 2000
I have a key wich could look like:
"07PLVEL SL4 54.1300 "
if I use SELECT * FROM "OMZETTEN" WHERE LEFT(KEY_2,7)='07PLVEL' works fine
but how to call if I want only keys like:
SELECT * FROM "OMZETTEN" WHERE LEFT(KEY_2,7)='07PLVEL' and mid(key_2,15,3) = 'SL4' this will give error
or
SELECT * FROM "OMZETTEN" WHERE mid(KEY_2,3,5)='07PLVEL' and mid(key_2,15,3) = 'SL4' this will give error
"07PLVEL SL4 54.1300 "
if I use SELECT * FROM "OMZETTEN" WHERE LEFT(KEY_2,7)='07PLVEL' works fine
but how to call if I want only keys like:
SELECT * FROM "OMZETTEN" WHERE LEFT(KEY_2,7)='07PLVEL' and mid(key_2,15,3) = 'SL4' this will give error
or
SELECT * FROM "OMZETTEN" WHERE mid(KEY_2,3,5)='07PLVEL' and mid(key_2,15,3) = 'SL4' this will give error
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.