like operator

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • adil
    #1

    like operator

    hallo
    i am trying to execute a sql-queerie like this " select ID where Name like
    ' test [' " but i doesn't work !!!i suggest that s ms access doesn't
    support no alphanumerics like " [ " . can any one help me ?

    best regards


    Tags: None
    • salad
      #2
      Re: like operator

      adil wrote:
      hallo
      i am trying to execute a sql-queerie like this " select ID where Name like
      ' test [' " but i doesn't work !!!i suggest that s ms access doesn't
      support no alphanumerics like " [ " . can any one help me ?
      >
      best regards
      >
      >
      are you searching for
      test [
      ?

      The [ and ] are used to define a range in a query.

      You could test for
      test [
      ....just not with the word Like

        Comment

        • ruralguy via AccessMonster.com
          #3
          Re: like operator

          Have you tried " select ID where Name like ' test [*' "

          I believe you will find the wildcard asterisk important.

          adil wrote:
          >hallo
          >i am trying to execute a sql-queerie like this " select ID where Name like
          >' test [' " but i doesn't work !!!i suggest that s ms access doesn't
          >support no alphanumerics like " [ " . can any one help me ?
          >
          >best regards
          --
          HTH - RuralGuy (RG for short) acXP WinXP Pro
          Please post back to this forum so all may benefit.

          Message posted via AccessMonster.c om
          http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200610/1


            Comment

            • Bob Quintal
              #4
              Re: like operator

              "adil" <adil_abdelali@ hotmail.comwrot e in
              news:4q1h0cFkpi 3dU1@news.dfnci s.de:
              hallo
              i am trying to execute a sql-queerie like this " select ID
              where Name like ' test [' " but i doesn't work !!!i suggest
              that s ms access doesn't support no alphanumerics like " [ " .
              can any one help me ?
              >
              best regards
              >
              >
              " select ID
              where Name like ' test [' " is incomplete.
              the [ wildcard must be part of a pair: []
              see the help.
              If you want o find 'test [' you must write
              'test [[]*'

              READ the help file section entitled wildcard.

              --
              Bob Quintal

              PA is y I've altered my email address.

              --
              Posted via a free Usenet account from http://www.teranews.com

                Comment

                • adil
                  #5
                  Re: like operator

                  thanks ,
                  i have already tried " select ID where Name like ' test [*' " it 's seems
                  to be the right solution but it doesn't work.
                  but when i use this " select ID where Name like 'test [[]*' " , like it
                  was suggested, it works .
                  i know now (thanks bob) the two statements should work but the fisrt
                  doesn't!!!
                  best regards



                  "Bob Quintal" <rquintal@sPAmp atico.caschrieb im Newsbeitrag
                  news:Xns9864965 FBF24CBQuintal@ 66.150.105.47.. .
                  "adil" <adil_abdelali@ hotmail.comwrot e in
                  news:4q1h0cFkpi 3dU1@news.dfnci s.de:
                  >
                  >hallo
                  >i am trying to execute a sql-queerie like this " select ID
                  >where Name like ' test [' " but i doesn't work !!!i suggest
                  >that s ms access doesn't support no alphanumerics like " [ " .
                  >can any one help me ?
                  >>
                  >best regards
                  >>
                  >>
                  " select ID
                  >where Name like ' test [' " is incomplete.
                  the [ wildcard must be part of a pair: []
                  see the help.
                  If you want o find 'test [' you must write
                  'test [[]*'
                  >
                  READ the help file section entitled wildcard.
                  >
                  --
                  Bob Quintal
                  >
                  PA is y I've altered my email address.
                  >
                  --
                  Posted via a free Usenet account from http://www.teranews.com
                  >

                    Comment

                    Previous template Next
                    Working...