displaying result by querying first 3 letters

[che_anj]

Hello can anybody tell me how to query the 3 order letters..

example is my code..

SELECT firstname, lastname, town, availability, expected_salary, keyword,dob,vacancy_type_id FROM rec_candidates WHERE keyword LIKE '%asp.net%';


tnx..

[mic2100]

ummm! i not sure what you mean exactly, could you be a bit more clear with what you are trying to do????

[guelphdad]

your query will pull up all records matching asp.net anywhere in the query. the problem though might be that each part of ASP and NET might be seen as separate words and are too short for the stopwords (i.e. this includes words under 4 letters in length).

is the problem you aren't getting matches or something else? you don't have an order by clause at all above so you won't get any ordering without it either.