like operator

[adil]

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

[salad]

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

[ruralguy via AccessMonster.com]

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.com
http://www.accessmonster.com/Uwe/For...ccess/200610/1

[Bob Quintal]

"adil" <ad***********@hotmail.comwrote in
news:4q************@news.dfncis.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

[adil]

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" <rq******@sPAmpatico.caschrieb im Newsbeitrag
news:Xn**********************@66.150.105.47...

"adil" <ad***********@hotmail.comwrote in
news:4q************@news.dfncis.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