sql skal tælle fra venstre

Kan du ikke bare bruge:

SELECT * FROM Ordbog
WHERE feltnavn Like "a*" OR felktnavn Like "b*" OR feltnavn  Like "c*")) OR feltnavn Like "d*"))

SELECT * FROM Ordbog WHERE Left([ord], 1) In ('a', 'b', 'c', 'd', 'e', 'f');

Eller kortere:

SELECT * FROM Ordbog WHERE Left([ord], 1) BETWEEN 'a' AND 'f';

This SQL makes an extra column containing a number 1 to 4 You then just need to make a select on this query instead of the table.
EXAMPLE: Name this query qryOrdbog for example

SELECT Ordbog.*, IIf([Engelsk]>="a" And [Engelsk]<"g",1,IIf([Engelsk]>="g" And [Engelsk1]<"m",2,IIf([Engelsk]>="m" And [Engelsk]<"s",3,4))) AS FirstChar
FROM Ordbog
ORDER BY Ordbog.Engelsk;

Then use for (a to f)

SELECT * from qryOrdbog where FirstChar = 1
or (g to l)
SELECT * from qryOrdbog where FirstChar = 2
.
.

NOTE:
You should make sure your database is using the Norwegian/Danish sort order. Yoú can check this in the Tools+Options+General menu. Then once this is done compact the database or the new sort order will not work.

morning proaccess :o)

morning, nice day again today...  sonny, with no rain...

Yes, its a great day, and as I'm off on holiday tomorrow then I expect it will be great weather the next three weeks or so :o)

THREE weeks, how will eksperten.dk survive...?

If I don't get a chance to say it later: "Have a nice holliday!"

Are you planning something special?

:o) I am sure you and all the other VERY competent users will keep it going.

We are off to Scotland on a Whisky Distillery tour. Hope to get some more material for my Homepage, if I do ever happen to get started on it.

Have you had your holidays?

Thanks :o)

Yep - 2 weeks off work, but heavyly overloaded with visits to friends and so on...  so now I'm as stressed as if I hadn't had my hollidays at all...  ;0(

Tak til alle, dat virker perfekt

Velbekomme