By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,347 Members | 2,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,347 IT Pros & Developers. It's quick & easy.

like operator

P: n/a
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
Oct 22 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Oct 22 '06 #2

P: n/a
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

Oct 22 '06 #3

P: n/a
"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

Oct 22 '06 #4

P: n/a
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

Oct 22 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.