Using LIKE instead of =

Results 1 to 3 of 3

Thread: Using LIKE instead of =

  1. #1
    Join Date
    Dec 1969

    Default Using LIKE instead of =

    Hi, In Bill Wilkinson article on how to display a category and sub categories ( He uses the following SQL code:<BR><BR>SQL = "SELECT * FROM Teams, Players " _<BR> & "WHERE Players.TeamID = Teams.TeamID " _<BR> & "ORDER BY Teams.TeamName, Players.PlayerName"<BR><BR><BR>I was wondering is it possible to use the "LIKE" clause here in place of the =. So you would have:<BR><BR>"WHERE Players.TeamID LIKE Teams.TeamID "<BR><BR>If so can someone explain what the syntax looks like? I have been trying to get this to work but with no luck.<BR><BR>Thanks in advance.

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Using LIKE instead of =

  3. #3
    Reggie Guest

    Default RE: Using LIKE instead of =

    I&#039;m not sure if you can use LIKE with ints. Did you use ints in your database design?

Posting Permissions

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