Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    44

    Unanswered: Split values in database

    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

  2. #2
    Join Date
    Jan 2005
    Posts
    362

    like


  3. #3
    Join Date
    Jan 2006
    Posts
    44
    Thanks.. but i dont want to use sql statement that uses like, cuase i have that in my another function..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •