Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxxAPC, How to unsubscrube from dategen spam, WWWXXXAPC, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text

Links

XODOX
Impressum

#1: distinguish between "-" and "_"

Posted on 2007-05-21 23:29:52 by leileili

Hello,

I encounter a problem when searching :

SELECT part_number, description FROM part WHERE part_number LIKE
"000-1_GB-01"

and

SELECT part_number, description FROM part WHERE part_number LIKE
"000-1-GB-01"

Both returns "000-1-GB-01". I expect to see the first search returns
"not found" since there's no"000-1_GB-01" in the database, only the
" . 000-1-GB-01".

Why it can't distinguish "-" and "_"? Does this related to
the setting in the database table ?

Thanks.

Lei

Report this message