Discuss "top 1 problem" in the SQL Development forum.

hi,

I have this table called codes

Id
Codename

I want to find the top first codename value

so here is my code

strs="SELECT TOP (1) Codename * FROM Codes"

I am using access

codename is text datatype

it gives an error

The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.ect.

any idea

todd

why do you have an asterisk (*) in there?

i would take that out and do an order by and desc.

as rebelle said ... remove the asterisk
and without using an ORDER BY clause, you could potentially get a different codename each time.

__________________
Quote of the Month:
Regret: It hurts to admit when you make mistakes - but when they're big enough, the pain only lasts a second.

Questions to Ponder:
Could it be that all those trick-or-treaters wearing sheets aren’t going as ghosts but as mattresses?

iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright © 2008 sbenj69

Besides what the others have said, what is it you are trying to select? "TOP 1" makes no sense without an ORDER BY clause.