Querying a comma delimited field

[lji_lists]

I have a field ("name") with a number of comma delimited values in it, say,
"Bob,Carol,Ted,Alice". How can I query to find all the records that include
the word "Ted"?

<CFQUERY NAME="foo" DATASOURCE="bar">
SELECT Address
FROM personal
WHERE name ???? "Ted"
</cfquery>

Thanks in advance for your help,
Les

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---