Re: Please help with tricky SQL statement....

This query isn't even in the first normal form. Normalize it and it will be a breeze to do what you want.

Regards
/Joachim
sjudkins_at_christyind.com wrote in message <6cv01b$rms$1_at_nnrp1.dejanews.com>...
>I am trying to build a SELECT statement that will select
>records from an "appointment" table. The appointment table
>looks like this:
>
>DATE DATE/TIME
>TEXT VARCHAR2
>APPTIDS VARCHAR2
>
>APPTIDS contains a comma-seperated list of the user IDs
>that is involved in the meeting. Example: '1,5,6'. I need a
>SELECT statement that will return only those rows that
>contain the ID of the current user (in the APPTIDS field)
>but, it can also contain the ID of other users).
>
>I need something like:
>
>"SELECT * FROM APPT WHERE #USERID# IN (IDS)"
>
>This returns rows that ONLY have the USERID in the APPTIDS
>field...instead of ones that contain the USERID AND other
>USERID's.
>
>Thanks for any help!
>Shayne
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Wed Feb 25 1998 - 00:00:00 CST