urgent help with comparison operators needed

[Guest_imported]

it looks like this--
"SELECT ass.projid, staffid, proj.projid, projname FROM ass, proj WHERE proj.projid=ass.projid AND ass.staffid like '%" & staffid & "%'"
im having trouble with the last part of the statement where comparing staffid's- the = operator isn't recognised and this 'like' operator is returning queries where the staffid is part of the other staffid. For example, its returning info for staff member 13,33 when it is staff mem 3!!
any quick suggestions would be fantastic..cheers people..

 

[Guest_imported]

SELECT ...
WHERE ...
AND ass.staffid like '%staffid%';

try that.

 

[tlbroadbent]

If StaffID is numeric, use =. It appears that you are dynamically building the SQL statement in code. Which client are you using and which RDMS are you querying?

If StaffID is a varuable in you program use the following sysntax. Of course the exact syntax depends on your client.

sSQL="SELECT ass.projid, staffid, proj.projid, projname
FROM ass, proj
WHERE proj.projid=ass.projid
AND ass.staffid = " & format(staffid)
Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[Guest_imported]

thanks for your all your help, it is now sorted...
the "& staffid &" worked it out after its conversion to an integer when i put it into the variable....