Hi..

I have a search function...

Inside my database, i have a few columns, with some data....
For test column, under 1 record, i have information like "a , b , c"

When i want to search, i enter "a". How do i search test column?

I cannot use "Select * from table WHERE test=" & request.form("enter")

Cause the value inside the database is "a , b , c"

How can i split my values in my database by a " , " when i search?

Thanx

You may need this http://www.1keydata.com/sql/sqllike.html
dimis

Thanks.. but i dont want to use sql statement that uses like, cuase i have that in my another function..