wildcard issues

Discussion in 'Classic ASP' started by joshbeagley, Feb 5, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. joshbeagley

    joshbeagley Guest

    Hello,

    I'm having issues with wildcards in my sql statements. The following does NOT work.

    SELECT * FROM T_people WHERE (facility = 'Tower') AND (crew = '%')

    I have a different server where this works fine, but not on discount.asp Any ideas? Thanks

    JB
     
    joshbeagley, Feb 5, 2006
    #1
  2. joshbeagley

    joshbeagley Guest

    Never mind I figured it out.

    In the statement use LIKE instead of =

    LIKE will search using wildcards and other types of wildcards.

    = will search using the literal characters that follow

    Something new every day
     
    joshbeagley, Feb 5, 2006
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page