dear,
i know the Query analyzer is helpful, yes but i try a lot of sql statement already on it... it still not working.... bcos dunno how to retrieve it with not using Instr.
ok, in the database a field called "User_Involved"... it store all the users name who involved in the event, and all the records(User name) is join togather and separate out with ","(commas)
Example :
record 1 : event 1 | Johnny,Allan,Tom
record 2 : event 2 | Tom
record 3 : event 3 | Allan,Alice,Patrick ....
what i want is when user login to my system
i will show the event who is involved in all the event, example i login as "Tom", i will get a record display like this:
Welcome, Tom
Event 1 : involved
Event 2 : involved
Event 3 : NOT involved
my SQL Statement is look like :
strSQL = "SELECT * FROM Event where Instr(USER_INVOLVED,',')='"&Session("USERID")&"'"