forespørgsel der kun søger på hele ord

= '$soegefelt'

øhh "soegefelt" skal stadig være en variabel - umiddelbart virker det du har foreslået ikke.. Gider du uddybe med et par eksempler

LIKE '*" & soegefelt & "*'

virker heller ikke!

can we see the complete SQL? Or even better send your dB to ekspertn@santhell.dk and I will take a look. I need to know waht to look at if you do send it!

morning :o)

"SELECT ditfelt FROM dintabel WHERE ditfelt Like '" & soegefelt & "';"

(søger på alle ord som bare indeholder "soegefelt" ordkombinationen et eller andet sted i ordet. )

terry - what do you mean? Is it because it has to be complete words or what?
Otherwise that should work - have it running in a DB myself where it looks up partial names.

I may be wrong but I understand the question to be able to find a "string" within the field, this would (i think) require
LIKE '*TheSubString*'

Terry you are absolutely right
I put the asterisks into the string prior to entering it into the sql:

strsrch = "*" & Me.TxtSrch.Value & "*"

strsql = "SELECT felt FROM tabel WHERE felt Like '" & strsrch & "';"

my mistake :-)

:o)

soegefelt = Request.Form("soegefelt")
strsrch = "*" & soegefelt & "*"
"SELECT f_id, articles_main.main as main FROM articles_main WHERE articles_main.main LIKE '" & strsrch & "';"

Dette her virker stadig ikke. Nu returnerer den slet ingen resultater - også selvom de søgte ord eksisterer i tabellen. Jeg har altså brug for en forespørgsel der søger på hele ord og ikke på ord hvor ordkombinationen blot findes i en del af ordet.

soegefelt = Request.Form("soegefelt")
strsrch = "*" & soegefelt & "*"
"SELECT f_id, articles_main.main as main FROM articles_main WHERE articles_main.main LIKE '*" & strsrch & "*';"

Request.Form!!!!
I see we are talking ASP, strange this creaps in now!

That doesn't work either - i get no results on words i am sure are in the articles_main.main column.

trine> Its just come to my notice that you are using ASP and as this category is Access then there will be things which we may not be able to help with.

Concerning the SQL, try the following, if it desont work then you need to check the contents of sSQL to make sure that it is correct.

soegefelt = Request.Form("soegefelt")

strsrch = "%" & soegefelt & "%"
sSQL = "SELECT f_id, articles_main.main as main FROM articles_main WHERE articles_main.main LIKE '" & strsrch & "'"