1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

query comma delimited field

Discussion in 'C#' started by birdz, Jun 16, 2010.

  1. #1
    I'm trying to select from a comma delimited field in an access database. The problem I have is using "like" gives me all the results that contain a 1 like 1, 11, 21, etc. How do I switch the query to only pull the results that actually equal 1 from within the comma delimted array?

    <%strSQL="SELECT * FROM products where category like '%1%' "
    Set rst = CreateObject("ADODB.Recordset")
    rst.Open strSQL, con, adOpenStatic, adLockReadOnly, adcmdText%>
    Code (markup):
    birdz, Jun 16, 2010 IP