SQL Access again
3 отговора
169 прегледа
SQL Access again
How can I write sql query in Access so to search for a string starting with..., or ending with..., for example, I would write this in MySQL:
SELECT * from AAA WHERE AAA LIKE 'John%';
to search for a string starting with John (I will find 'John is good guy' for example)
or
SELECT * from AAA WHERE AAA LIKE '%is good %';
to find the same
But this does not work in ACCESS
Please healp me to solve this
Thank you
SELECT * from AAA WHERE AAA LIKE 'John%';
to search for a string starting with John (I will find 'John is good guy' for example)
or
SELECT * from AAA WHERE AAA LIKE '%is good %';
to find the same
But this does not work in ACCESS
Please healp me to solve this
Thank you
Re: SQL Access again
Виж къде е разликата. Виж и това.
П.П. Това бяха първите два линка при търсене с google.com по ключови думи: access sql like expression.
__________________________________
Пътят към ада е осеян с добри намерения
П.П. Това бяха първите два линка при търсене с google.com по ключови думи: access sql like expression.
__________________________________
Пътят към ада е осеян с добри намерения
Редактирано от ..:: StanProg ::.. на
Re: SQL Access again
Ooo tochno za towa wleznah da pitam,
ta, probvai neshto takova::
SELECT PER_FNAME , PER_SNAME
FROM PERSONS
WHERE ([PER_FNAME] LIKE '*John*');
Problema mi e kakwo stawa ako vmesto John pishesh [Киро], e Access97 se smazwa pod kirilicata.. kakwo da prawja rowseta mi e pylen s bokluk..
ta, probvai neshto takova::
SELECT PER_FNAME , PER_SNAME
FROM PERSONS
WHERE ([PER_FNAME] LIKE '*John*');
Problema mi e kakwo stawa ako vmesto John pishesh [Киро], e Access97 se smazwa pod kirilicata.. kakwo da prawja rowseta mi e pylen s bokluk..