Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    12

    Angry Unanswered: Like operator NOT WORKING

    hello, i got a table named client in contains the field id (primary key), Cname, Phonenumber etc.. i have this sql code:

    SELECT Client.[ID], Client.[Cname], Client.[address], Client.[NetworkIP], Client.[Antenna_Name], Client.[Antenna_SSID]
    FROM Client
    WHERE Client.[Cname] Like 'jac%';

    i am not getting any results although i have a client named 'jack something'
    any help

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    try

    WHERE Client.[Cname] LIKE 'jac*';

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2009
    Posts
    12
    thanks a lot it works

Posting Permissions

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